when I tried to synchronize the users between Joomla! and SMF, I got this error:
Quote
Joomla/Mambo[0] / SMF[0] inserted Failed : : Failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'22f127e Joomla-SMF Forum Installation Joomla/Mambo[0] / SMF[0] inserted Failed : : Failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \\\'22f127e038\\\'\\\')\\\' at line 1 SQL=INSERT INTO smf_members (realName, memberName, emailAddress, passwd, dateRegistered, hideEmail, is_activated, validation_code) VALUES (\\\'russiansuck\\\',\\\'russiansuck\\\' ,\\\'sfd@uspie.net\\\' ,\\\'c8f874d9f6058f87bc8338691db295c2ac76bf4d\\\', UNIX_TIMESTAMP(\\\'2007-04-18 16:02:50\\\'), 0, 1, \\\'\\\'22f127e038\\\'\\\') ~~~ FROM::/home/pandaig/domains/panda-greatwall.com/public_html/administrator/components/com_smf/admin.smf.class.php || createsmfuser || 645
what mysql version and editor are you using? (I use phpmyadmin as an example)
this code here seems to be telling you to read the guides that come with mysql editors like phpmyadmin. It wants you to look up sytax and look near \'22f127e for the error.. then you can fix it.
The problem with this theory is that the syntax cant be wrong if smf is working properly... obviousely if smf works then the databse is fine...
obviously if joomla works then the database is fine... but for some reason CB is reading the database as wrong.... makes me wonder if your not using some incompatable mysql manager or something... I have no idea... this is all specualtion.
Were I in your situation i would one by one uninstall and reinstall CB, SMF_JOOMLA Bridge, and the CB_SMF Plugin they all make use of both databases. perhaps that will fix the problem... make sure you are using the latest stable versions of each.
I am not the help here and only point out what i feel is the problem and solution. The help here is busy with bugs and new versions and such and have limited staff. I am not quallified to repair advanced php but have experienced my own share of problems and fixed them. If my advice is unwelcome or inacurate in any way please do not hold this website responsable. i wish you good luck.
Logged
If all else fails. and all of mans technology has revealed no answer to your problem... poke it untill it gives up.
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
Author
Forum
Logged
