SQL Error

Home

Forum SQL Error

	Welcome, Guest. Please login or register. Did you miss your activation email? October 10, 2008, 08:01:42 PM

Joomla Forum

Joomla Hacks

Joomla-SMF Forum Support

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

SQL Error

0 Members and 1 Guest are viewing this topic.

« previous next »

Pages: [1]

Author

Topic: SQL Error (Read 760 times)

Ion

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 2

SQL Error

« on: September 17, 2007, 10:38:59 AM »

when i try to install the jsmf 2.0.2 i recive an SQL Error:

DB function failed with error number 1366
Incorrect integer value: '' for column 'id' at row 1 SQL=INSERT INTO jos_components VALUES( '', 'Joomla-SMF Forum', 'option=com_smf', 0, 0, 'option=com_smf', 'Joomla-SMF Forum', 'com_smf', 0, 'js/ThemeOffice/component.png', 0, '' )
SQL =
INSERT INTO jos_components
VALUES( '', 'Joomla-SMF Forum', 'option=com_smf', 0, 0, 'option=com_smf', 'Joomla-SMF Forum', 'com_smf', 0, 'js/ThemeOffice/component.png', 0, '' )

who can pls help me?:-s


	Logged

owpdanpooler

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 1

Re: SQL Error

« Reply #1 on: September 17, 2007, 03:10:55 PM »

I also receive this error.
Failed:Error verifying user synchronization.: db_error:Table \\\'our0721410484739.smf_members\\\' doesn\\\'t exist SQL=SELECT count(*) FROM smf_members LEFT JOIN jos_users ON jos_users.username=smf_members.memberName WHERE jos_users.username IS NULL1

I believe both SMF and Joomla need to be in the same database. But how to you put both systems into one database? I'm using godaddy.com to host. Anyone help?