PDA

View Full Version : Getting these errors when I run the 3.4.2 SQL lines


Ski-Whiz
04-16-2005, 12:18 PM
I'm getting these when I run the upgrade directions:


Error

SQL-query :

ALTER TABLE `".TABLE_PREFIX."user` ADD COLUMN `alerts` int( 5 ) default '0'

MySQL said:


#1103 - Incorrect table name '".TABLE_PREFIX."user'


AND


Error

SQL-query :

ALTER TABLE `".TABLE_PREFIX."warning_types` ADD COLUMN `warn_alert` char( 3 ) default 'No'

MySQL said:


#1103 - Incorrect table name '".TABLE_PREFIX."warning_types'




Now, I've got 3.4.1 installed and running good on 3.0.7, and I'll probably go in my database and make these changes manually. The wierd part is, those tables are there! :D

Just letting you know, or maybe it's me?

sv1cec
04-16-2005, 01:05 PM
Are you using a table prefix in your setup? If not, remove the ".TABLE_PREFIX." part. If you are, you have to replace that with whatever your table prefix is.

Rgds

Ski-Whiz
04-16-2005, 01:13 PM
I just added the tables manually..

I just copied the lines into my query window (tried in admincp querey window, and in phpadmin on the server). I copied one line at a time, and got those..

hmm, not a big deal to me.. I just went in and created them myself.. :D Took like 20 seconds longer than if I got those lines to work for my configuration.. :D

sv1cec
04-16-2005, 01:32 PM
Glad you have it all sorted out.

Rgds