×

Error

Please login first

Database error

13 years 2 months ago #156721 by tubaboy
Database error was created by tubaboy
Hi, using 1.4, joomla 1.5.22- I'm getting these errors when I run the database tool to fix the errors:

Other symptom is I get the dreaded white screen when trying to save a profile- any help appreciated!!


CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `hits` int(11) NOT NULL DEFAULT 0 )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `hits` int(11) NOT NULL DEFAULT 0 )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: 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 ')ENGINE=MyISAM' at line 2 SQL=CREATE TABLE `jos_comprofiler` ( )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__users failed with SQL error: Table 'jos_users' already exists SQL=CREATE TABLE `jos_users` ( `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' )ENGINE=MyISAM
CREATE TABLE `#__users` ( `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__users failed with SQL error: Table 'jos_users' already exists SQL=CREATE TABLE `jos_users` ( `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' )ENGINE=MyISAM
CREATE TABLE `#__users` ( `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `lastupdatedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `lastupdatedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: 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 ')ENGINE=MyISAM' at line 2 SQL=CREATE TABLE `jos_comprofiler` ( )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: 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 ')ENGINE=MyISAM' at line 2 SQL=CREATE TABLE `jos_comprofiler` ( )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: 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 ')ENGINE=MyISAM' at line 2 SQL=CREATE TABLE `jos_comprofiler` ( )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: 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 ')ENGINE=MyISAM' at line 2 SQL=CREATE TABLE `jos_comprofiler` ( )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__users failed with SQL error: Table 'jos_users' already exists SQL=CREATE TABLE `jos_users` ( `username` varchar(100) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '' )ENGINE=MyISAM
CREATE TABLE `#__users` ( `username` varchar(100) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '' )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__users failed with SQL error: Table 'jos_users' already exists SQL=CREATE TABLE `jos_users` ( `username` varchar(100) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '' )ENGINE=MyISAM
CREATE TABLE `#__users` ( `username` varchar(100) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '' )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__users failed with SQL error: Table 'jos_users' already exists SQL=CREATE TABLE `jos_users` ( `username` varchar(100) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '' )ENGINE=MyISAM
CREATE TABLE `#__users` ( `username` varchar(100) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '' )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__users failed with SQL error: Table 'jos_users' already exists SQL=CREATE TABLE `jos_users` ( `username` varchar(100) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '' )ENGINE=MyISAM
CREATE TABLE `#__users` ( `username` varchar(100) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '' )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__users failed with SQL error: Table 'jos_users' already exists SQL=CREATE TABLE `jos_users` ( `email` varchar(100) NOT NULL DEFAULT '' )ENGINE=MyISAM
CREATE TABLE `#__users` ( `email` varchar(100) NOT NULL DEFAULT '' )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__users failed with SQL error: Table 'jos_users' already exists SQL=CREATE TABLE `jos_users` ( `username` varchar(100) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '' )ENGINE=MyISAM
CREATE TABLE `#__users` ( `username` varchar(100) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '' )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__users failed with SQL error: Table 'jos_users' already exists SQL=CREATE TABLE `jos_users` ( `password` varchar(100) NOT NULL DEFAULT '' )ENGINE=MyISAM
CREATE TABLE `#__users` ( `password` varchar(100) NOT NULL DEFAULT '' )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__users failed with SQL error: Table 'jos_users' already exists SQL=CREATE TABLE `jos_users` ( `params` text NOT NULL )ENGINE=MyISAM
CREATE TABLE `#__users` ( `params` text NOT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_genres` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `cb_genres` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `location` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `location` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `website` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `website` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_bio` mediumtext )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `cb_bio` mediumtext )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_artistmember` tinyint(3) unsigned DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `cb_artistmember` tinyint(3) unsigned DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_instruments` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `cb_instruments` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: 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 ')ENGINE=MyISAM' at line 2 SQL=CREATE TABLE `jos_comprofiler` ( )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: 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 ')ENGINE=MyISAM' at line 2 SQL=CREATE TABLE `jos_comprofiler` ( )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: 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 ')ENGINE=MyISAM' at line 2 SQL=CREATE TABLE `jos_comprofiler` ( )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `avatar` varchar(255) DEFAULT NULL, `avatarapproved` tinyint(4) NOT NULL DEFAULT 1 )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `avatar` varchar(255) DEFAULT NULL, `avatarapproved` tinyint(4) NOT NULL DEFAULT 1 )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `occupation` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `occupation` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `interests` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `interests` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `company` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `company` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `city` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `city` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `state` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `state` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `zipcode` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `zipcode` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `country` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `country` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `address` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `address` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `phone` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `phone` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `fax` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `fax` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_intro` mediumtext )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `cb_intro` mediumtext )ENGINE=MyISAM
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_getmusic` mediumtext )ENGINE=MyISAM
CREATE TABLE `#__comprofiler` ( `cb_getmusic` mediumtext )ENGINE=MyISAM

Please Log in to join the conversation.

13 years 1 month ago #157844 by tubaboy
Replied by tubaboy on topic Re: Database error
I've done a database repair in php admin, so those errors don't show up- but I still have the white screen when trying to save an edit to a profile.

Any suggestions much appreciated.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.158 seconds