Database Error

Home

Forum Database Error

	Welcome, Guest. Please login or register. Did you miss your activation email? December 04, 2008, 07:12:29 PM

Joomla Forum

Joomla Hacks

Joomla-SMF Forum Support

Joomla-SMF 2.0.x (Moderators: -Wolverine, kai920)

Database Error

0 Members and 1 Guest are viewing this topic.

« previous next »

Pages: [1]

Author

Topic: Database Error (Read 1639 times)

scottb

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 5

Database Error

« on: December 31, 2006, 04:02:53 PM »

I am installing SMF 1.1.1 on an old site that uses Mambo 4.5.3. The owner does not want to switch to Joomla right now but his com_phpBB component was hacked. I have salvaged his users and posts

I am using:

Joomla SMF 2.0 Final
Mambo 4.5.3
SMF 1.1.1

This from the installation page:

installed      SMF Forum installed on the same database as Joomla.
done [un-patch]    Patch Joomla Source Files.
done [un-patch]    Patch SMF Source Files (Note: Unpatch before upgrading SMF or installing mod.)
sync realnames
sync usernames    Optional: Synchronize Joomla and SMF users(username or real name).

The path is correct and the SMF data table prefix is smf_

I get this error when I try to sync the usernames:

Joomla/Mambo[0] / SMF[0] inserted Failed :Unknown column \\\'activation\\\' in \\\'field list\\\' SQL=SELECT name, username, password, email, registerDate, block, activation FROM mos_users LEFT JOIN smf_members ON smf_members.memberName = mos_users.username WHERE smf_members.memberName IS NULL ~~~ FROM::/home/webadmin/the-site.com/html/administrator/components/com_smf/admin.smf.class.php || syncusers || 488

Am I missing something?


	Logged

FidelGonzales

Joomla Newbie

Karma: +0/-6
Offline

Offline

Posts: 35

Re: Database Error

« Reply #1 on: January 02, 2007, 07:57:35 AM »

OFF-TOPIC: I switched from PHPBB on several non-Joomla sites due to numerous hacks even when keeping the install up to date.


	Logged

Mister T

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 18

Re: Database Error

« Reply #2 on: January 10, 2007, 02:14:12 PM »

I've got the same issue...
(and the bridge does not work in Joomla)

Any suggestion ?
Thanks.


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: Database Error

« Reply #3 on: January 10, 2007, 02:16:35 PM »

using phpmyadmin check the table mos_users in your install, is there a field named activation?


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Mister T

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 18

Re: Database Error

« Reply #4 on: January 10, 2007, 02:27:57 PM »

Oups... In fact, the bridge is working, despite the error message...
So, I'm very happy anyway Wink

Now, if someone could explain what this message is about, it would be interesting (but not critical anymore)

Thanks,

P.S.: running Joomla 1.0.12, SMF 1.1.1, Bridge 2.0.4


	Logged

Mister T

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 18

Re: Database Error

« Reply #5 on: January 10, 2007, 02:30:25 PM »

Quote from: -Wolverine on January 10, 2007, 02:16:35 PM

using phpmyadmin check the table mos_users in your install, is there a field named activation?

Table "jos_users" (as I'm running Joomla), and yes: there is such a field, and this field is not empty for some of my users....


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: Database Error

« Reply #6 on: January 10, 2007, 03:53:35 PM »

post your error then, it can't be exactly the same if what you just posted is true.


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Mister T

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 18

Re: Database Error

« Reply #7 on: January 11, 2007, 03:42:22 AM »

Hi,
Yes, you're right: only the beginning is the same, I didn't notice it... Sorry...

Here is my message:

Quote

Joomla/Mambo[0] / SMF[0] inserted Failed :Anonymous : Failed : Saisissez votre nom. /var/www/acd_comm/backup_20070108/Joomla/administrator/components/com_smf/admin.smf.class.php createJoomlaUser 576

Note that "Saisissez votre nom" mean "enter your name" in French...

Thanks again


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: Database Error

« Reply #8 on: January 11, 2007, 11:21:05 AM »

That means that username has no realname associated with it. Find that user via db tool like phpmyadmin and add a name. Otherwise you cannot sync them from SMF to Joomla.


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Mister T

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 18

Re: Database Error

« Reply #9 on: January 11, 2007, 12:36:54 PM »

100% right !
Thanks to your advice I dig a little bit in my DB, and I found several inconsistencies, which are now cleaned up...

Then, the synchronization worked ! Perfect !

Thanks a lot for your support, and many thanks for your tools... Grin


	Logged

Ivan Krstić

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 1

Database Error

« Reply #10 on: January 11, 2007, 02:31:22 PM »

I get an error at the installation of the com_smf version 2
after a successfully install in joomla back-end, i get an error in the component install option. the error is saying that the SMF Table prefix is not smf_, now i have checked the database and the prefix for the data base is smf_, so what and where did i do wrong?

i hope some one can help?