All pastes #179378 Raw Edit

Stuff

public text v1 · immutable
#179378 ·published 2006-09-22 04:55 UTC
rendered paste body
rver: localhostlocalhost  	
	Database: room719_nuke3room719_nuke3
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 3146
STR: `
SQL: 
ALTER TABLE `nuke_bbauth_access` ADD auth_news` tinyint(1) NOT NULL default '0');
ALTER TABLE `nuke_bbauth_access` ADD `auth_download` tinyint(1) NOT NULL default '0');
ALTER TABLE `nuke_bbforums` ADD `thank` tinyint(1) NOT NULL default '0';
ALTER TABLE `nuke_bbforums` ADD   `auth_news` tinyint(2) NOT NULL default '2';
ALTER TABLE `nuke_bbforums` ADD   `auth_download` tinyint(2) NOT NULL default '0';
ALTER TABLE `nuke_bbposts` ADD `post_attachment` tinyint(1) NOT NULL default '0';
ALTER TABLE `nuke_bbprivmsgs` ADD `privmsgs_attachment` tinyint(1) NOT NULL default '0';
ALTER TABLE `nuke_bbsmilies` ADD `smile_stat` mediumint(8) unsigned NOT NULL default '0';
ALTER TABLE `nuke_bbtopics` ADD `news_id` int(10) unsigned NOT NULL default '0';
ALTER TABLE `nuke_bbtopics` ADD `topic_attachment` tinyint(1) NOT NULL default '0';
ALTER TABLE `nuke_bbtopics` KEY `news_id` (`news_id`);
ALTER TABLE `nuke_bbvote_voters` ADD `vote_cast` tinyint(4) unsigned NOT NULL default '0';
ALTER TABLE `nuke_downloads_downloads` ADD `ns_compat` varchar(30) NOT NULL default '';
ALTER TABLE `nuke_downloads_downloads` ADD `ns_des_img` varchar(100) NOT NULL default '';
ALTER TABLE `nuke_downloads_modrequest` ADD `ns_compat` varchar(30) NOT NULL default '';
ALTER TABLE `nuke_downloads_modrequest` ADD `ns_des_img` varchar(100) NOT NULL default '';
ALTER TABLE `nuke_downloads_newdownload` ADD `ns_compat` varchar(30) NOT NULL default '';
ALTER TABLE `nuke_downloads_newdownload` ADD `ns_des_img` varchar(100) NOT NULL default '';
ALTER TABLE `nuke_users` ADD `user_from_flag` varchar(25) default NULL;
ALTER TABLE `nuke_users` ADD `user_profile_view_popup` tinyint(1) default '1';
ALTER TABLE `nuke_users` ADD `user_birthday` int(11) NOT NULL default '999999';
ALTER TABLE `nuke_users` ADD `user_next_birthday_greeting` int(11) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `agreedtos` tinyint(1) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `user_gender` tinyint(4) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `user_profile_view` smallint(5) unsigned NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `user_last_profile_view` int(11) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `user_color_gc` varchar(6) default '';
ALTER TABLE `nuke_users` ADD `user_color_gi` text;
ALTER TABLE `nuke_users` ADD `kick_ban` int(2) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `user_sudoku_playing` int(1) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `user_coloku_playing` int(1) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `user_lexoku_playing` int(1) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `daily_post_count` tinyint(3) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `daily_post_limit` tinyint(3) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `daily_post_period` int(11) NOT NULL default '0';
ALTER TABLE `nuke_users` ADD `user_allow_arcadepm` tinyint(4) NOT NULL default '1';
ALTER TABLE `nuke_users_temp` ADD `realname` varchar(255) NOT NULL default '';






CREATE TABLE `nuke_bandwidth_readings` (
  `date` timestamp NOT NULL default,
  `speed` float NOT NULL default '0',
  `ip` text NOT NULL,
  `name` text NOT NULL
) ENGINE=MyISAM;

SQL query:

ALTER TABLE `nuke_bbauth_access` ADD auth_news` tinyint(1) NOT NULL default '0'); ALTER TABLE `nuke_bbauth_access` ADD `auth_download` tinyint(1) NOT NULL default '0'); ALTER TABLE `nuke_bbforums` ADD `thank` tinyint(1) NOT NULL default '0'; ALTER TABLE `nuke_bbforums` ADD `auth_news` tinyint(2) NOT NULL default '2'; ALTER TABLE `nuke_bbforums` ADD `auth_download` tinyint(2) NOT NULL default '0'; ALTER TABLE `nuke_bbposts` ADD `post_attachment` tinyint(1) NOT NULL default '0'; ALTER TABLE `nuke_bbprivmsgs` ADD `privmsgs_attachment` tinyint(1) NOT NULL default '0'; ALTER TABLE `nuke_bbsmilies` ADD `smile_stat` mediumint(8) unsigned NOT NULL default '0'; ALTER TABLE `nuke_bbtopics` ADD `news_id` int(10) unsigned NOT NULL default '0'; ALTER TABLE `nuke_bbtopics` ADD `topic_attachment` tinyint(1) NOT NULL default '0'; ALTER TABLE `nuke_bbtopics` KEY `news_id` (`news_id`); ALTER TABLE `nuke_bbvote_voters` ADD `vote_cast` tinyint(4) unsigned NOT NULL default '0'; ALTER TABLE `nuke_downloads_downloads` ADD `ns_compat` varchar(30) NOT NULL default ''; ALTER TABLE `nuke_downloads_downloads` ADD `ns_des_img` varchar(100) NOT NULL default ''; ALTER TABLE `nuke_downloads_modrequest` ADD `ns_compat` varchar(30) NOT NULL default ''; ALTER TABLE `nuke_downloads_modrequest` ADD `ns_des_img` varchar(100) NOT NULL default ''; ALTER TABLE `nuke_downloads_newdownload` ADD `ns_compat` varchar(30) NOT NULL default ''; ALTER TABLE `nuke_downloads_newdownload` ADD `ns_des_img` varchar(100) NOT NULL default ''; ALTER TABLE `nuke_users` ADD `user_from_flag` varchar(25) default NULL; ALTER TABLE `nuke_users` ADD `user_profile_view_popup` tinyint(1) default '1'; ALTER TABLE `nuke_users` ADD `user_birthday` int(11) NOT NULL default '999999'; ALTER TABLE `nuke_users` ADD `user_next_birthday_greeting` int(11) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `agreedtos` tinyint(1) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `user_gender` tinyint(4) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `user_profile_view` smallint(5) unsigned NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `user_last_profile_view` int(11) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `user_color_gc` varchar(6) default ''; ALTER TABLE `nuke_users` ADD `user_color_gi` text; ALTER TABLE `nuke_users` ADD `kick_ban` int(2) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `user_sudoku_playing` int(1) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `user_coloku_playing` int(1) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `user_lexoku_playing` int(1) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `daily_post_count` tinyint(3) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `daily_post_limit` tinyint(3) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `daily_post_period` int(11) NOT NULL default '0'; ALTER TABLE `nuke_users` ADD `user_allow_arcadepm` tinyint(4) NOT NULL default '1'; ALTER TABLE `nuke_users_temp` ADD `realname` varchar(255) NOT NULL default ''; CREATE TABLE `nuke_bandwidth_readings` ( `date` timestamp NOT NULL default, `speed` float NOT NULL default '0', `ip` text NOT NULL, `name` text NOT NULL ) ENGINE=MyISAM;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ' tinyint(1) NOT NULL default '0');
ALTER TABLE `nuke_bbauth_ac