Reply to thread

Message

<blockquote data-quote="Logic" data-source="post: 424539" data-attributes="member: 12691">So there's an error on your part if there are tables missing. Either manually add them or delete your database and execute a new one. Also, that wasn't a fix for the issue with the diamonds table missing, it was one for a common error you will receive in your emulator when placing furniture down in-game. However, try the below steps.1) Keep in mind step 2 will consist of dropping the `server_rewards` &amp; `subscriptions` tables. Backup your database if you made any changes to those 2 tables.2) Open your database and run the following as SEPARATE queries:[code]DROP TABLE IF EXISTS `server_rewards`;CREATE TABLE `server_rewards` (&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp; `reward_start` int(11) NOT NULL DEFAULT '0',&nbsp; `reward_end` int(11) NOT NULL DEFAULT '0',&nbsp; `reward_type` enum('credits','badge','diamonds','duckets','none') NOT NULL DEFAULT 'none',&nbsp; `reward_data` varchar(255) NOT NULL,&nbsp; `message` varchar(255) NOT NULL,&nbsp; `enabled` enum('1','0') NOT NULL DEFAULT '1',&nbsp; PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;[/code][code]DROP TABLE IF EXISTS `subscriptions`;CREATE TABLE `subscriptions` (&nbsp; `diamonds` int(11) NOT NULL DEFAULT '0',&nbsp; `id` int(10) NOT NULL DEFAULT '0',&nbsp; `name` varchar(50) NOT NULL,&nbsp; `badge_code` varchar(10) NOT NULL,&nbsp; `credits` int(11) NOT NULL DEFAULT '100',&nbsp; `duckets` int(11) NOT NULL DEFAULT '100',&nbsp; `respects` int(11) NOT NULL DEFAULT '3',&nbsp; PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;[/code]</blockquote>

[QUOTE="Logic, post: 424539, member: 12691"] So there's an error on your part if there are tables missing. Either manually add them or delete your database and execute a new one. Also, that wasn't a fix for the issue with the diamonds table missing, it was one for a common error you will receive in your emulator when placing furniture down in-game. However, try the below steps. 1) Keep in mind step 2 will consist of dropping the `server_rewards` & `subscriptions` tables. Backup your database if you made any changes to those 2 tables. 2) Open your database and run the following as [B]SEPARATE[/B] queries: [code] DROP TABLE IF EXISTS `server_rewards`; CREATE TABLE `server_rewards` ( `id` int(11) NOT NULL AUTO_INCREMENT, `reward_start` int(11) NOT NULL DEFAULT '0', `reward_end` int(11) NOT NULL DEFAULT '0', `reward_type` enum('credits','badge','diamonds','duckets','none') NOT NULL DEFAULT 'none', `reward_data` varchar(255) NOT NULL, `message` varchar(255) NOT NULL, `enabled` enum('1','0') NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;[/code] [code] DROP TABLE IF EXISTS `subscriptions`; CREATE TABLE `subscriptions` ( `diamonds` int(11) NOT NULL DEFAULT '0', `id` int(10) NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL, `badge_code` varchar(10) NOT NULL, `credits` int(11) NOT NULL DEFAULT '100', `duckets` int(11) NOT NULL DEFAULT '100', `respects` int(11) NOT NULL DEFAULT '3', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;[/code] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members