• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Problem creating guilds

Hokku

Member
Joined
Jul 25, 2013
Messages
95
Reaction score
17
Location
Extremadura, Spain
Hello, recently moved my db from Xamp to Uniserver, i cleaned it and seems to work fine, but last night i noticed when i try to create a guild this appear:


e2png_wapqaee.png


i followed this post Solved - Gesior acc Guild with ID 0 doesn't exist. when creating guild (https://otland.net/threads/gesior-acc-guild-with-id-0-doesnt-exist-when-creating-guild.233879/) ,when i try to create the guilds table i get this message
Sin título.png

I debugged data base in index and this is what appear:

Lua:
Query:    INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo`) VALUES ('Wrath', '421', '1591874134', '', 'New guild. Leader must edit this text :)', '', '1591874134;data:image/gif;base64,R0lGODlhQABAAPcAAAAAAAgAABAAABgAABgIACEIACkIADEIADkIADkQAEIQAEoQAFIQAFoQAFoYAGMYAGNjUmsYAGtKAGtjUmtjWmtrWnMYAHNSAHNrWnNrY3sYAHshAHtSAHtaAHtzY3tza4QhAIRaAIRaCIRjCIR7a4R7c4whAIxjCIyEc4yEe5QhAJRrCJSMe5wpAJxrCJxzCJyMe5yMhJyUhKUpAKVzCKV7CKWUhKWcjK0pAK17CK2cjLUpALV7CLWECLWllLWtlL0xAL2ECL2MCL21nMYxAMaMCMaUCMa1pc4xAM6UCM69rdYxANY5ANaUCNacCN45AO/exvfnzv///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEAAFEALAAAAABAAEAAAAj+AKNECQCgIMEACBMaNKjwIEIACR82XAhRosOCAjNqDICECJKPHkMyCYlkpEgiTEqq7IgSpMmSKVN+BNkxZQAbGjUCGFmyZcqWPUkyGYpy6JOiQHl6jElzJpGQAEjgzDlQJdGYQzu6rPkxa9aiVn3K5Nn1KcioU3MGYBqz6EilMJdyNQtTJkiUHruydEkEgIcYVKuaHAuz7tCYT8h6NVoT79XDkLMiAZCBRWAAM4mufIl3JRIgIBwYSJDAgQocMz0Xppl3JmXLVDH/3NEChIkWLXZk1rsjAcIDFm6rsJBAgAAFQGTiJdIiAoMECxQ42DDjKZMAlS8TYVAQgIADCxL+GCAgIEABC0+BGAAQAQgRHBEWjHZgAggQBwAIuN9QvuBxBc+t99AO2MGW004BnJBEEUk0mIQRRghRxAsHEAQACEy0QABBB0QAAggPbBjABupVZEEQCz7YIIMNBhFABAVelmEBD46gAGkXXFADiwUEAEQLEIFQV00pAQlRBD1IWIQRQbwwQgdQjlAEgwDs8Fpga03WQxHHmaDCAwwQ0J0CTCwQQAcAbCAZSQQG8ICEEl7wUAGlMaAAAAckUcNaV8aW0gMJOFGDbJkZ4AASvgXB4AH6FUaECQAk0EOEgx6UXF42iZDEAg9clx1VWRIRwKQFbJBZBAYgUYACCxDwYBH+KwRgAl5mKigEDQUAoICPChxgF3MATBkASjGCCtJzTvQAgFvDPrAWEb0BkIOEBThAhJg5JBHErip0ZMGwsn4VwApJMLCATZ8e6BQALxQhgQEjKbBBCz6qRIQKADQoxHoCSDjoAul5VJqVS4lWhLItFauuSvQmKYADQHAEwKxD9hVAEELQKcQJAYBARHIduedjAhZkCEAQRnS8lMI69TQSaUwWFAG+Lmv11K6K5hdAdVrZ+4ACOFQJAA1FRKAAV32q6xYTBHQgYQAOEPBATyyZBSkAQgRxYWpPLSc0ACvAylHVSbf800cR21oeanlZ9xkA3yZQRA7DOpWZqBvYKUT+rCCfle5Gv3oUsab7GoBD12WN10MPCSbxgAF0mQVtAQWYEMAIAFTXGhNlZ7QT1UQcFfEDD56AmXVPBZ2DEXeeLIQAM6Q2EpC5Bg2ACpq11LlAmKVGk7MG9ICyA1AD0RHlRgw6QwIKFCFC3U/NAIABKyBcJVtmsez5UkTltcD0AGiq7a5SBzBttR+bXwQAuT1QUAcMuiDAZFhpxvnfnn/FFBIOFABjAAaggRAkNIIAHEAIdJuBAgtggCIkJAE7ytqudrIslxxmMvgTSJYyYxIVyKoARAABQuAnBAC4IAl0Iw9CKHeCGqBMCD34XgFw4KNlYco9HdldFHbikSewJCX+EYtYVzbgn2AJYVRTSpKEMEYDZxlQNypIAL1a0zMMGkgnZlnTSIZVpcwAgYFzC0COLiCCCzCgRwRRgArctoAIOIABZEEcErTHu8QgwYeSUxUIEhCBljxFakWwgAGIIx4D7GoFg9ILSgAQMZ7FZSZ03GHkgAIEy00RdQKggREK4KiRAEB4w6KLByOGujh66oqeI5Jq5jiDAJSsa64L5SMLMIIkFEA3LNlZAhigFcbARIe9o1pYiCg99zwlX0fkydloua8WLMUCMxyWciJjRSz18iedmeMDiGefVjZoLV9BSQGMUIQDmCAlrQSCAEqmHLd9RIccIUlZVBK0FpQHCPj+ahABukaWcRbBARgCkgoYcAC6KKU1kbSh/rzyGYHmKgLBSoI0sUmEcZZrAx40gbPi4jYfwiShclFkFYkIAu5gLZlWSYk/fZO57xnvbkxZCjzt9ZKrtARIBmhBjxgwNsWMMwgE0A8BDtCVt9wlmzPlzP5288Xb3QciBFjVeAoCIfOozC4XlMxPQIopYbaTYRB5QG5a4IAFtLFh6zOAe7CylcK8BZ5Ysc5Sl7KUA5TVQgEggAESUgSURi4sQ/oIV0uCR+WAjiWoMkIOClCbDczLAvnqwLmAYq8fhrOafjrKT65iLz++bUGMVI4BLmDLGbzEKYiTXFbgmU3HdMWjqg3+QLsU0EcgBqAILhqLZOz2lt4m1W2QoWw2GWCAmIXkcUkQAQP+SsWiJiWSoTQq94BLUSAYMVxzfBrb7li1uJAlNSCtrFXu1raRFOBNLxiWdJKwggR85i2OyeNj3pnBHSoFvtc8DFA+dtLyXOx1OxiK8eJ4Nw4Ktr69Qx1fVhI6qjHBkNoSQNjslJSuOcYkF95ifcfWkaNMly1nI4q0FmSEF1RQqXIVb3cT6jvN7EZyKEnMowJghCSUcI3zPAlXckxfVPIucBecy3SB0j+gLtdl+lPkV1eG4K+o2HduSw4QE6CrKubYj+F0m6g2TKTp9pJ7Rt0tjrMYZgOzFSs63GH+YHsb18joVy5spSJkegm6AFDAAzIIjH3tVtTdsFkx9QOLR+f63S1SgAQ30LMkd4vkBdOEJ5qlM5Kz6paETaC+GVHCTnCoW0wt+Yc9GzCGdTsXm0AAA4hWtECGUJClxtWykpZnFS/Ytq4UZAKozrOqVy2DUE5SVBKpyLIkExGIGKTDYpkjBCiQARLoetervkGxGUIBCmAgA9jOdt2us+wKZDvb3VkIQihQgQ+kINHQ1ogSfCCDEnjg2xnwAAlQwIJ625sFEiO3B+h973qjgATv/rYHSiADH6Q7MEPQgQz6LQN0U8UHAQA4CRTtgxss/N4y0MHBNw7tIdwAMBwPucgLVe3wKEBh5IoOCAAAOw==')
SQLSTATE:    HY000
Driver code:    1366
Error message:    Incorrect integer value: '' for column 'create_ip' at row 1
 
Back
Top