| Help processing SQL manually | |
Posted: 12/01/2005 5:28 AM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 9:23 PM
|
|
|
|
|
|
This is the Error Easy Mod gave - while installing the MOD: Users set Posts & Topics count
The mod is installed and seems to be working except I did not process the below SQL yet, my questions:
Since the mod seems to be working do I need to add this SQL to my phpMyAdmin?
I know how to add the new SQL table but it says to add after? How do add an SQL after a certain table?
Thanks
Quote:
|
SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually
The following error occured:
Error:
Unexpected or unknown attribute "AFTER USER_ALLOWSMILE", in "user_postspp VARCHAR(4) AFTER user_allowsmile", statement: 1, table: "phpbb_users"
SQL:
ALTER TABLE phpbb_users ADD user_postspp VARCHAR(4) AFTER user_allowsmile
|
|
|
|
|
|
Back to Top |
|
|
| Help processing SQL manually | |
Posted: 12/01/2005 5:44 AM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 10:23 PM
Location: St Pete, FL
|
|
|
|
|
|
You should run this and all other included SQL statements in phpMyAdmin...
Code:
|
ALTER TABLE phpbb_users ADD user_postspp VARCHAR(4) AFTER user_allowsmile
|
|
|
Last edited by Nightrider on 12/01/2005 5:49 AM; edited 2 times in total |
|
|
|
Back to Top |
|
|
| Help processing SQL manually | |
Posted: 12/01/2005 5:46 AM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 9:23 PM
|
|
|
|
|
|
The way you showed me? It says to ALTER TABLE phpbb_users ADD user_postspp VARCHAR(4) AFTER user_allowsmile; |
|
Last edited by Jaddon on 12/01/2005 5:49 AM; edited 1 time in total |
|
|
|
Back to Top |
|
|
| Help processing SQL manually | |
Posted: 12/01/2005 5:49 AM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 10:23 PM
Location: St Pete, FL
|
|
|
|
|
|
The AFTER part of the statement will put the field directly after the user_allowsmile field. I really don't see a good reason to do that unless they are relying on the fields to be in a particular order in the SQL statement. That would be a dumb way to code it though if that is the case because it is possible that another MOD will come along and screw up the order again...
Yes, do it exactly like you did the restored queries...
|
|
|
|
|
Back to Top |
|
|
| Help processing SQL manually | |
Posted: 12/01/2005 5:52 AM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 9:23 PM
|
|
|
|
|
|
It says to ALTER TABLE phpbb_users ADD user_postspp VARCHAR(4) AFTER user_allowsmile;
so what is the SQL code I add?
Do I add this whole code? ALTER TABLE phpbb_users ADD user_postspp VARCHAR(4) AFTER user_allowsmile; |
|
|
|
|
Back to Top |
|
|
| Help processing SQL manually | |
Posted: 12/01/2005 5:55 AM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 10:23 PM
Location: St Pete, FL
|
|
|
|
|
|
Yes, that syntax is correct. EM 0.3.0 just doesn't know what the AFTER statement does so it didn't bother winging it. Just run the statement exactly as you see it in phyMyAdmin...
|
|
|
|
|
Back to Top |
|
|
| Help processing SQL manually | |
Posted: 12/01/2005 5:58 AM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 9:23 PM
|
|
|
|
|
|
I ran it and got this in phyMyAdmin after running it
Error
SQL query:
ALTER TABLE phpbb_users ADD user_postspp VARCHAR( 4 ) AFTER user_allowsmile
MySQL said: Documentation
#1060 - Duplicate column name 'user_postspp' |
|
|
|
|
Back to Top |
|
|
| Help processing SQL manually | |
Posted: 12/01/2005 6:00 AM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 9:23 PM
|
|
|
|
|
|
in the install file for the mod is says this:
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_users ADD user_postspp VARCHAR(4) AFTER user_allowsmile;
ALTER TABLE phpbb_users ADD user_topicspp VARCHAR(4) AFTER user_postspp;
so the 2nd sql code em added only got an error for the first code but now in phpmyadmin it is talking about the 2nd code. confused. |
|
|
|
|
Back to Top |
|
|
| Re: Help processing SQL manually | |
Posted: 12/01/2005 6:04 AM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 10:23 PM
Location: St Pete, FL
|
|
|
|
|
|
Jaddon wrote:
|
#1060 - Duplicate column name 'user_postspp'
|
This error means that the field has already been added to the table. You don't have to run this command after all because it is already done...
Try running the next statement...
|
|
|
|
|
Back to Top |
|
|
| Help processing SQL manually | |
Posted: 12/01/2005 6:08 AM |
|
|
|
|
Citation |
Posts |
3160 |
Word Cnt. |
157,169 |
BDay |
Mar 11 |
Sign |
Pisces |
Sex |
|
|
|
|
Joined: Oct 12, 2005
Local time: 9:23 PM
|
|
|
|
|
|
getting an error for that one to. mmmm maybe em added it after all. LOL
The mod seems to be working fine so guess it is alset then. Going to add it to my real board now.
Thanks |
|
|
|
|
Back to Top |
|
|
| Information | |
|