upgrade to 1.15 database error message

[Bec]

hi everyone,

i did my upgrade earlier this morning everything went fine but I have just tried to install a new smiley set and received this error message

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.5, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.

can somebody please help... i am only new to all of this so have no idea what needs to be done!

thank you!!

[metallica48423]

anything in the error log? (check both the one for the forum AND the webserver, if possible, please)

[Bec]

hi metallica, (nice name btw) thank you for your reply!

i have 5 pages in my forum error log - they all seem to come from File: /home/buctai8/public_html/Sources/Subs.php - undefined index for a few of my mods (gallery, file manager, staff page etc etc)

and my server is pretty full of errors as well (just a few)....

[Fri May  2 01:07:56 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/404.shtml
[Fri May  2 01:07:56 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/SmoothGallery/css/jd.gallery.css
[Fri May  2 01:07:56 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/404.shtml
[Fri May  2 01:07:56 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/SmoothGallery/scripts/jd.gallery.js
[Fri May  2 01:07:55 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/404.shtml
[Fri May  2 01:07:55 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/SmoothGallery/scripts/mootools.v1.11.js
[Fri May  2 01:07:47 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/404.shtml
[Fri May  2 01:07:47 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/SmoothGallery/css/jd.gallery.css
[Fri May  2 01:07:47 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/404.shtml
[Fri May  2 01:07:47 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/SmoothGallery/scripts/jd.gallery.js
[Fri May  2 01:07:47 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/404.shtml
[Fri May  2 01:07:47 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/SmoothGallery/scripts/mootools.v1.11.js
[Fri May  2 01:07:42 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/404.shtml
[Fri May  2 01:07:42 2008] [error] [client 124.148.85.29] File does not exist: /home/buctai8/public_html/Themes/Outline_tp/images/english-utf8/new2.gif

[Bec]

also just wondering my database stuffed up a while ago and i had a friend reinstall for me... when i look in on my database i have the following...

buctai8_SMF
buctai8_smf1

im pretty sure smf1 is the main one, is it ok to delete the other one? i did a check on both and only the smf1 bought everything up (and my backups are smf1)...  and also when i look in cpanel at my version of smf it says unknown and that i need to do a manual upgrade... im sorry for all the questions but i have absolutely no idea!

[Aleksi "Lex" Kilpinen]

To make sure, I think you could use repair_settings to see which prefix it is currently using.
What is repair_settings.php?

[Rafferty]

I got the same error immediately on applying the upgrade . Repair Settings doesn't fix it

[Bec]

Rafferty have you fixed your problem?

I just did the repair settings.... how do I know if it fixed anything? My forum error log is up to 9 pages and counting...

my cookie value is SMFCookie835 should i change this to the recommended SMFCookie11??

and my Output Compression: is set to on should I turn this off?

sorry and thank you!

[Aleksi "Lex" Kilpinen]

Sorry, I did not intend the repair_settings.php as a fix to your problem, but only to find out which database the forum was using, since you asked about it.

[Bec]

LexArma no i appreciate your advice, i have since removed the other database, so thank you heaps! if anything at least im tidying things up in there. thank you!

[Bec]

ive also got this in my database section...

Connection Strings
Perl   $dbh = DBI->connect("DBI:mysql:buctai8_smf1:localhost","buctai8_smf1new","<PASSWORD HERE>");
PHP   $dbh=mysql_connect ("localhost", "buctai8_smf1new", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("buctai8_smf1");

any ideas?

[Rafferty]

So what was the answer to the original problem, the dbase being identified as not compatible, reporting 1.1.4 after upgrade to 1.1.5?

[metallica48423]

that error is irrelevant and isn't a problem (there has been no db chages since 1.1.1).  it is not the problem the problem is that there was a database error

check your forum and webserver error logs for any database related errors.

[Shawn Gotti]

same problem. i get this error:

Database Error: 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 'LENGTH(code) DESC' at line 2
File: XXXXXX/forum/Sources/ManageSmileys.php
Line: 654

[metallica48423]

thats not the same problem.

A search of this site turns this error up many times.

Its a mysql bug.

http://docs.simplemachines.org/index.php?topic=1079.msg2548#msg2548

[Bec]

Metallica, my server error log contains smoothgallery error messages from yesterday (i have just removed smoothgallery so hopefully that eliminates that from happening) in my forum error log i have the following...

File: /home/buctai8/public_html/Sources/Subs.php (for mods such as file manager, staff page, links etc etc)

8: Undefined index: d_thank_you_remove_warn
File: /home/buctai8/public_html/Themes/default/Display.template.php (main sub template - eval?)

I updated my language files last night (as they are showing as version 1.1 rather than 1.15 - my default is english) i played around with my database settings prior to doing the upload and they all appeared and seemed to resolve the problem but ever since i upgraded my language files last night the error messages have appeared again, i am now up to page 44 in my error log... and the mod options are no longer showing in my admin panel... any ideas?

Thank you for your help!

[metallica48423]

yes, the custom strings for your mods were probably removed when you did so.

you'll either need to manually readd them or uninstall and reinstall all of your mods.

[Bec]

ok cool, phew i was worried it was something really bad, thank you for your help and quick response! its greatly appreciated!!

cheers!
bec

[Bec]

Me again,

Just to confirm, alot of them wont uninstall using the package manager so next step would be to manually go into my language files etc and make the changes for each mod using package parser??  they have a conflict in all the default and language files.... just want to confirm before i go making any changes...

Cheers!

[metallica48423]

Are they failing only on the language files?

[Bec]

default/languages
sources
/Themes/default/index.template.php

pretty much and some of them like file manager, smf byu dont even have the option to uninstall