Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Q&A
[R63B] mySQL issues
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Sledmore" data-source="post: 232922" data-attributes="member: 591"><p>Some strange errors there (I say strange because you should have not encountered some).</p><p></p><p>This query should fix the groups issue:</p><p>[PHP]ALTER TABLE `groups`</p><p>MODIFY COLUMN `Petitions` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;[/PHP]</p><p></p><p>The next error (ip_cache) query error, you shouldn't encounter as it shouldn't be enabled, seems that someone ran the :language command.</p><p></p><p>This query should fix it (but I'd suggest disabling that command):</p><p>[PHP]</p><p>CREATE TABLE `ip_cache` (</p><p>`id` int(11) NOT NULL AUTO_INCREMENT ,</p><p>`username` varchar(25) NULL DEFAULT '' ,</p><p>`ip` int(11) NULL ,</p><p>PRIMARY KEY (`id`));[/PHP]</p><p></p><p>The next error is an error pointing out that the `activity_points_lastupdate` field size is too small/value entered is too large, try this:</p><p></p><p>[PHP]ALTER TABLE `users`</p><p>MODIFY COLUMN `activity_points_lastupdate` double(5,0) NOT NULL DEFAULT 0;[/PHP]</p><p></p><p>Okay, for this error you shouldn't of encountered this, so this query will delete the `is_activated` row and then re-add it giving all default values a value of '0'.</p><p></p><p>[PHP]ALTER TABLE `user_effects`</p><p>DROP COLUMN `is_activated`,</p><p>ADD COLUMN `is_activated` enum('0','1') NULL DEFAULT '0' AFTER `total_duration`;[/PHP]</p><p></p><p>Here is a query that should fix the current issue with pets and future issues (I downloaded a database and gave it some random values, since mine is clean):</p><p></p><p>[PHP]ALTER TABLE `user_pets`</p><p>MODIFY COLUMN `room_id` int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `user_id`,</p><p>MODIFY COLUMN `expirience` int(11) NOT NULL DEFAULT 0 AFTER `type`,</p><p>MODIFY COLUMN `energy` int(11) NOT NULL DEFAULT 100 AFTER `expirience`;[/PHP]</p><p></p><p>You shouldn't encounter the issue that you are having with the moodlights but this should fix it: (It will TURN OFF all current moodlights)</p><p></p><p>[PHP]ALTER TABLE `items_moodlight`</p><p>DROP COLUMN `enabled`,</p><p>ADD COLUMN `enabled` enum('0','1') NULL DEFAULT '0' AFTER `item_id`;[/PHP]</p><p></p><p>This next error could be due to the fact that the navigator tries to update the values to nothing or it could be your database, try this:</p><p></p><p>[PHP]ALTER TABLE `rooms`</p><p>MODIFY COLUMN `allow_pets` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1' AFTER `landscape`,</p><p>MODIFY COLUMN `allow_pets_eat` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1' AFTER `allow_pets`;[/PHP]</p><p></p><p>You may have to do some fixes to your source, but some of the querys should help you.</p></blockquote><p></p>
[QUOTE="Sledmore, post: 232922, member: 591"] Some strange errors there (I say strange because you should have not encountered some). This query should fix the groups issue: [PHP]ALTER TABLE `groups` MODIFY COLUMN `Petitions` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;[/PHP] The next error (ip_cache) query error, you shouldn't encounter as it shouldn't be enabled, seems that someone ran the :language command. This query should fix it (but I'd suggest disabling that command): [PHP] CREATE TABLE `ip_cache` ( `id` int(11) NOT NULL AUTO_INCREMENT , `username` varchar(25) NULL DEFAULT '' , `ip` int(11) NULL , PRIMARY KEY (`id`));[/PHP] The next error is an error pointing out that the `activity_points_lastupdate` field size is too small/value entered is too large, try this: [PHP]ALTER TABLE `users` MODIFY COLUMN `activity_points_lastupdate` double(5,0) NOT NULL DEFAULT 0;[/PHP] Okay, for this error you shouldn't of encountered this, so this query will delete the `is_activated` row and then re-add it giving all default values a value of '0'. [PHP]ALTER TABLE `user_effects` DROP COLUMN `is_activated`, ADD COLUMN `is_activated` enum('0','1') NULL DEFAULT '0' AFTER `total_duration`;[/PHP] Here is a query that should fix the current issue with pets and future issues (I downloaded a database and gave it some random values, since mine is clean): [PHP]ALTER TABLE `user_pets` MODIFY COLUMN `room_id` int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `user_id`, MODIFY COLUMN `expirience` int(11) NOT NULL DEFAULT 0 AFTER `type`, MODIFY COLUMN `energy` int(11) NOT NULL DEFAULT 100 AFTER `expirience`;[/PHP] You shouldn't encounter the issue that you are having with the moodlights but this should fix it: (It will TURN OFF all current moodlights) [PHP]ALTER TABLE `items_moodlight` DROP COLUMN `enabled`, ADD COLUMN `enabled` enum('0','1') NULL DEFAULT '0' AFTER `item_id`;[/PHP] This next error could be due to the fact that the navigator tries to update the values to nothing or it could be your database, try this: [PHP]ALTER TABLE `rooms` MODIFY COLUMN `allow_pets` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1' AFTER `landscape`, MODIFY COLUMN `allow_pets_eat` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1' AFTER `allow_pets`;[/PHP] You may have to do some fixes to your source, but some of the querys should help you. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
[R63B] mySQL issues
Top