Log in Register FAQ Memberlist Search Welcome to RCF - New Forum Index
alt : test.swf
Welcome to RCF - New
4fx3.gif 
Contact the Webmasters of RCFContact   Invite a friend to Join usRecommend   Chat in IRCChat   EZ Template Change OptionEZStyle   Listen to Internet Radio while you browse...iRadio   See your private message.Login for PMs   Important LinksLinks
Member Website LinksWeb Links   Play/View our GamesGames   Register.Register
calendar_open_closeCalendar 
Help processing SQL manually
Post new topic   Reply to topic View previous topic :: View next topic
Goto page: 1, 2  Next
Welcome to RCF - New Forum Index -> Area 51 - phpBB & Easymod Tech Support Add To Bookmarks
Help processing SQL manually
PostPosted: 12/01/2005 5:28 AM Reply with quote
Citation
Jaddon
Citation
Posts 3160
Word Cnt. 157,169
BDay Mar 11
Sign Pisces
Sex Sex:Female
Joined: Oct 12, 2005
Local time: 6:13 PM
usaCa.gif
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
View user's profile Find all posts by Jaddon Send private message   Visit poster's website Phoogle Map
Help processing SQL manually
PostPosted: 12/01/2005 5:44 AM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30756
Word Cnt. 2,628,677
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 7:13 PM
Location: St Pete, FL
peace.gif
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


munky2


Last edited by Nightrider on 12/01/2005 5:49 AM; edited 2 times in total
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
Help processing SQL manually
PostPosted: 12/01/2005 5:46 AM Reply with quote
Citation
Jaddon
Citation
Posts 3160
Word Cnt. 157,169
BDay Mar 11
Sign Pisces
Sex Sex:Female
Joined: Oct 12, 2005
Local time: 6:13 PM
usaCa.gif
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
View user's profile Find all posts by Jaddon Send private message   Visit poster's website Phoogle Map
Help processing SQL manually
PostPosted: 12/01/2005 5:49 AM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30756
Word Cnt. 2,628,677
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 7:13 PM
Location: St Pete, FL
peace.gif
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...

munky2
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
Help processing SQL manually
PostPosted: 12/01/2005 5:52 AM Reply with quote
Citation
Jaddon
Citation
Posts 3160
Word Cnt. 157,169
BDay Mar 11
Sign Pisces
Sex Sex:Female
Joined: Oct 12, 2005
Local time: 6:13 PM
usaCa.gif
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
View user's profile Find all posts by Jaddon Send private message   Visit poster's website Phoogle Map
Help processing SQL manually
PostPosted: 12/01/2005 5:55 AM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30756
Word Cnt. 2,628,677
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 7:13 PM
Location: St Pete, FL
peace.gif
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...

headbang
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
Help processing SQL manually
PostPosted: 12/01/2005 5:58 AM Reply with quote
Citation
Jaddon
Citation
Posts 3160
Word Cnt. 157,169
BDay Mar 11
Sign Pisces
Sex Sex:Female
Joined: Oct 12, 2005
Local time: 6:13 PM
usaCa.gif
Shocked  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
View user's profile Find all posts by Jaddon Send private message   Visit poster's website Phoogle Map
Help processing SQL manually
PostPosted: 12/01/2005 6:00 AM Reply with quote
Citation
Jaddon
Citation
Posts 3160
Word Cnt. 157,169
BDay Mar 11
Sign Pisces
Sex Sex:Female
Joined: Oct 12, 2005
Local time: 6:13 PM
usaCa.gif
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
View user's profile Find all posts by Jaddon Send private message   Visit poster's website Phoogle Map
Re: Help processing SQL manually
PostPosted: 12/01/2005 6:04 AM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30756
Word Cnt. 2,628,677
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 7:13 PM
Location: St Pete, FL
peace.gif
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...

headbang
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
Help processing SQL manually
PostPosted: 12/01/2005 6:08 AM Reply with quote
Citation
Jaddon
Citation
Posts 3160
Word Cnt. 157,169
BDay Mar 11
Sign Pisces
Sex Sex:Female
Joined: Oct 12, 2005
Local time: 6:13 PM
usaCa.gif
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.  Smile  Going to add it to my real board now.

Thanks
Back to Top
View user's profile Find all posts by Jaddon Send private message   Visit poster's website Phoogle Map
 Post new topic  Reply to topic
Information
Welcome to RCF - New Forum Index -> Area 51 - phpBB & Easymod Tech Support

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
All times are GMT - 5 Hours
Goto page: 1, 2  Next
Page 1 of 2


Add To Bookmarks

 
  
  


  Google

Powered by phpBB © 2001, 2005 phpBB Group
  ImageShack  
  Putfile  
  TinyURL  
  CommonDreams  
  Log in  

Page generation time: 0.1269s (PHP: 77% - SQL: 23%) - SQL queries: 60 - GZIP enabled - Debug on