Simpleboard error installation

wavi · 18.05.2004, 13:43

Hi,

I have mambo 4.5 1.07 (upgrade from 1.06)

Like install Simpleboard 1.0-RC4

But get this error :

Upload new component - error
DB function failed with error number 1136
Column count doesn't match value count at row 1 SQL=INSERT INTO mos_components VALUES('','Simpleboard Forum','option=com_simpleboard','0','0','option=co m_simpleboard','Simpleboard Forum','com_simpleboard','0','js/ThemeOffice/component.png',0)
SQL =
INSERT INTO mos_components VALUES('','Simpleboard Forum','option=com_simpleboard','0','0','option=co m_simpleboard','Simpleboard Forum','com_simpleboard','0','js/ThemeOffice/component.png',0)

Any can help my (..every) resolve this ??

Thankyou replier
wavi

Tigros · 19.05.2004, 21:14

Don't thank me

I am only adding an issue to yours...

Mambo 4.5 1.0.7
SimpleBoard 1.0 RC4

Error

SQL-query :

INSERT INTO `mos_components` ( `name` , `link` , `menuid` , `parent` , `admin_menu_link` , `admin_menu_alt` , `option` , `ordering` , `admin_menu_img` , `iscore` , `comdir` , `admindir` )
VALUES (
'Simpleboard Forum', 'option=com_simpleboard', 0, 0, 'option=com_simpleboard', 'Simpleboard Forum', 'com_simpleboard', 0, 'js/ThemeOffice/component.png', 0, '/srv/ziduldorintelor.ro/administrator/components/com_simpleboard/', '/srv/ziduldorintelor.ro/administrator/administrator/components/com_simpleboard/'
)

MySQL said:
#1054 - Unknown column 'comdir' in 'field list'

If I remove the two field lists, I get another sql query error... I haven't copied that one to paste it here... But maybe someone has experience with this and has solved the issue?
I used the exact query from the simpleboard site and install documentation...

Thanx in advance for any solution...

Daniel

Baal · 20.05.2004, 02:37

I had a similar problem trying to instal Simple Board. Are you using the original username and password generated by Mambo? For some reason it only seems to instal properly when you use the original username and password. In the end I had to do a clean install (as I didn't have the original user/password anymore) and it worked fine.

Also I found that certain modules wreck havock with it (in my case it was phpshop - if it was on the left I got an error; if it was on the right I got no errors - odd huh?), try turning off all non standard install modules - and if you're using a three column template turn off all mods on the right column of you forum page.

Hope this helps.

Tigros · 20.05.2004, 16:21

I reset the passwords to the original ones... and still doesn't work... can it be something different? Or maybe they got crypted differently... dunno...

Still get the same sql error...

Daniel

Baal · 20.05.2004, 19:47

If you don't have much content on the site yet try re-installing, and using the default admin name and password - make it the first component you install, and again make sure you have no other components in the left or right column (other than the default) - for instance on my site if I have the php_shop module in either column on the forum page, I will get an error code. Good luck.