Why don't my installed mods and settings save?

[Joseph Fung]

Check the following things
a) can you modify the agreement?
b) can you post messages?
c) do most other areas of your board work?

If you answered yes to them, the cause is most likely because of an incorrect reporting of the MySQL version.

In MySQL 3.23 you can use the LIMIT 1 syntax in update queries.  This is not so for 3.22.

Unfortunately, if you are running in Safe Mode, or if something else causes the mysql version to be reported incorectly, YaBB SE will think it can use that syntax when it shouldn't!

The solution for this is to manually disable the LIMIT 1 syntax.

To do this, open index.php and on line 48 you will find

Code Select Expand

$doLimitOne = (substr($row[0],0,4) >= 3.23)?' LIMIT 1':'';

change this to

Code Select Expand

$doLimitOne = '';

and upload the changed file.  This should work.

[TheJkWhoSaysNi]

A) No
B) Yes
C) Yes and no, see http://www.yabb.info/community/index.php?board=2;action=display;threadid=2871

What should I do?

[Sensor]

Seems to work for me!

Thanks:)

[Brad]

Is the index.php part of SE or mySQL? and where would I find it?

Hope I'm not sounding stupid.

Brad

[iamdamnsam]

that did not do a thing for me.  I did notice when I installed without converting, the everything would save.  After converting a YaBB Gold board, it stops saving for the installed mods section.  Everything else saves.

[Daniel Hofverberg]

Everything worked fine for me in earlier versions of YaBB SE (1.1.0 and 1.3.0), but since I installed 1.4.0 I can no longer save the settings on that screen.

To answer the questions in the original post: Everything else works just fine.

Version of PHP: 4.0.6, running in safe mode
Version of MySQL: 3.23.36

The server is running Apache 1.3.19 on Red Hat Linux.

As the MySQL version is newer than 3.22, the reason Joseph posted about in the original post doesn't seem to apply...

Any ideas?

[hz]

I seem to have the same problem.
I changed the background colors of my board and saved them successfully but they don't show up after reloading my board.
All other changes worked fine upto now, including pasting my logo into the board.
What's wrong?
Harald Zellerer

[Hypocrite]

I seem to have the same problem.
I changed the background colors of my board and saved them successfully but they don't show up after reloading my board.
All other changes worked fine upto now, including pasting my logo into the board.
What's wrong?
Harald Zellerer

You have to edit the colours both in the admin section and in the template.php to make them work properly in every place of the board.