sql error again

**igeoffi** · 06-22-2005, 01:25 AM

i got an sql error again

Quote:

An error occurred trying to update the database
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 ')' at line 33

im installing phpbb with a few mods pre-installed
here is the two sql files
http://www.pacrim.pwnagehost.com/bet...sql_schema.sql
http://www.pacrim.pwnagehost.com/bet...ysql_basic.sql

i dont know what is wrong

**leavethisplace** · 06-22-2005, 06:58 AM

none of those files have an update statement near the line 33 - are you sure its the SQL that has the problem? as it could be the PHP files that are executing SQL that is more likely causing the problem. Does the error message not give you the name of the root file??

**igeoffi** · 11:37 AM

it doesnt give me the name of the file with the error
i dont its a php error cuz it says you have an error in your sql syntax

**leavethisplace** · 06-22-2005, 01:29 PM

this is true, however, if there is an SQL statement in the PHP then it will throw this error up - you said you're installing PHPBB with hacks, so look through the hack files to see if any update SQL statements are being used. Also, u may want to check the website where you got the hack from to see if anyone has posted the same problem on the site forum, with a resolve.

**igeoffi** · 02:42 PM

is there a way to rewrite

Code:

CREATE TABLE `phpbb_shout` (
  `shout_id` mediumint(8) unsigned NOT NULL auto_increment,
  `shout_username` varchar(25) NOT NULL default '',
  `shout_user_id` mediumint(8) NOT NULL default '0',
  `shout_group_id` mediumint(8) NOT NULL default '0',
  `shout_session_time` int(11) NOT NULL default '0',
  `shout_ip` varchar(8) NOT NULL default '',
  `shout_text` text NOT NULL,
  `shout_active` mediumint(8) NOT NULL default '0',
  `enable_bbcode` tinyint(1) NOT NULL default '0',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '0',
  `enable_sig` tinyint(1) NOT NULL default '0',
  `shout_bbcode_uid` varchar(10) NOT NULL default '',
  KEY `shout_id` (`shout_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

to something like

Code:

# --------------------------------------------------------
#
# Table structure for table 'phpbb_shoutbox’
#
CREATE TABLE phpbb_shoutbox (
   shout_id MEDIUMINT(8) UNSIGNED NOT NULL auto_increment, 
   shout_username VARCHAR(25) NOT NULL, 
   shout_user_id MEDIUMINT(8) NOT NULL, 
   shout_group_id MEDIUMINT(8) NOT NULL,
   shout_session_time INT(11) NOT NULL, 
   shout_ip CHAR(8) NOT NULL, 
   shout_text TEXT NOT NULL, 
   shout_active MEDIUMINT(8) NOT NULL, 
   enable_bbcode TINYINT (1) NOT NULL,
   enable_html TINYINT (1) NOT NULL,
   enable_smilies TINYINT (1) NOT NULL,
   enable_sig TINYINT (1) NOT NULL,
   shout_bbcode_uid VARCHAR(10) NOT NULL,
   INDEX (shout_id)
);

**leavethisplace** · 06-23-2005, 06:32 AM

wait a sec, i've just noticed something i've not noticed before. The line below should be taken out

PHP Code:


			
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

i've come across this error myself before and that seemed to sort it out no problem at all - i believe it's either a mySQL or myPHPAdmin error - either way, try it.

**igeoffi** · 06-24-2005, 08:58 PM

no it works
my question is how do you re-write it like the ssecond one?