Home arrow Forum Sync issue.. missing field in table?
  Welcome, Guest. Please login or register.
Did you miss your activation email?
December 02, 2008, 12:45:03 AM
Home New Posts Search Calendar


Login with username, password and session length
+  Joomla Forum
|-+  Joomla Hacks
| |-+  Joomla-SMF Forum Support
| | |-+  Joomla-SMF 1.0.x (Moderators: -Wolverine, kai920)
| | | |-+  Sync issue.. missing field in table?		 0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: Sync issue.. missing field in table?  (Read 1434 times)
WheatKing
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 2


View Profile
Sync issue.. missing field in table?
« on: November 15, 2005, 12:03:07 PM »
 Huh

getting this error when attempting to sync the forum and the joomla users..

Code:
Success : Mambo[0] / SMF[DB function failed with error number 1054Unknown column \'activation\' in \'field list\' SQL=SELECT name, username, password, email, registerDate, block, activation FROM jos_users LEFT JOIN smf_members ON smf_members.memberName = jos_users.username WHERE smf_members.memberName IS NULL] inserted

So i checked the jos_users table and sure enough there is no activation field.  is my joomla just borked? or is something else wrong here.

ahh should state the following as well..

Joomla 1.0.3
SMF 1.1 RC1
Joomla SMF 1.0.2a
« Last Edit: November 15, 2005, 12:05:25 PM by WheatKing » Logged
WheatKing
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 2


View Profile
Re: Sync issue.. missing field in table?
« Reply #1 on: November 15, 2005, 12:15:55 PM »
Just figured it out..  Roll Eyes

Seems i was playing with phpBB and the ugly hack of a mess that it is earlier.. and it screwed the jos_users table by adding and removing a bunch of fields..

Luckily i had a backup and the site isn't really live yet.. and well.. highly recommend to EVERYONE.. well.. backup before modding..

amazing what a simple little change can do to make your life hell.. LOL
Logged
Pages: [1] Go Up Print 
« previous next »
Jump to:  



Login with username, password and session length

Powered by MySQL Powered by PHP Joomla Forum | Powered by SMF 1.1 RC1.
© 2001-2005, Lewis Media. All Rights Reserved.
Joomla Bridge by JoomlaHacks.com 		Valid XHTML 1.0! Valid CSS!

Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved.
Terms of Use
Joomla Hacks



Joomla Hacks
 German Lang French Lang Italian Lang Spanish Lang Japanese Lang Chinese Lang
Search Contact About Advertise Blogs Topsites Submit News Register Login