SQLError:1054 Unknown column 'u.user_custom_title' in 'field

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   re: SQLError:1054 Unknown column 'u.user_custom_title' in 'f
mrhyde
CZ Newbie
mrhyde has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jul 26, 2004
0.00 posts per day
Posts: 1
Points: 194
   
All, I've come across the same error multiple times (see first post for error statement) - In the title_install.php could someone please copy and paste the SQL code for myphpadmin - I've tried locating the code, but again, I'm just a n00b with this php stuff.

Any help would be greatly appreciated as I think it's about 99% ready to run....


icon_mrgreen.gif



Back to top Reply with quote
#2   
carcinogen
CZ Newbie
carcinogen has been a member for over 20 year's 20 Year Member
Age: 37
Gender: Female
Status: Offline
Joined: Jul 10, 2004
0.00 posts per day
Posts: 16
Points: 1,986
   
Sorry for asking redundant questions, but as I'm new to this, just checking ... by "file the sql statements", do you mean add the following ?

This installs the necessary database schema for Aexoden\'s Custom Title MOD.  Currently, only the MySQL aspect has been tested.  If you\'re using any other database, please report your results to Aexoden.</p>' . "\n";

switch ( SQL_LAYER )
{
   case 'mysql':
   case 'mysql4':
      $sql[] = "ALTER TABLE " . USERS_TABLE . "
         ADD COLUMN user_custom_title varchar(255) NULL,
         ADD COLUMN user_custom_title_status tinyint(1) default '0' not null";
      break;
}


That's it, right (I deleted the rest because I'm on MySQL) ? I just have to add those two columns manually by phpMyAdmin, or is there something else I'm missing ?


Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
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