Author
Topic: SQL logic error or missing database (Read 33935 times)

w5hro

I'm using SMF version 2.0.7 and an SQLite database install and I need to be able to set some member options via the Administration Center » Themes and Layout » Member Options location and I've been getting the error below. I need this to work with it. I've had this error ever since I first installed SMF. The SQLite version on my server is SQLite 3.3.6

w5hro

I just looked at the stock file and there's no reference to "GROUP" around line 433. So, I guess the first question has to be "What mods are you using?".

I actually had this error with the stock installation when I first installed the SMF package before I even installed any mods. However, with a few mods installed the line number may have changed to 433 and differs now from the stock file.

w5hro

Ok, here is line 428 to 426, maybe the line gets shifted down from 428 in the Themes.php file to line 433 in the actual application after all of the files get pulled up as a whole, but the error does say "around" line 433.

The only thing I've noticed now though is that once and a while when clicking on a topic, function or a link I get an error page with the following message, but it only happens every once and a while.

Notice: Undefined variable: err_msg in /home/mylocation/public_html/Sources/Subs-Db-sqlite3.php on line 374database is locked

Not sure what that is, but if I look at line 374 I see some code above and below it that looks like it might be some kind of delay or overload timing for the database connection. Any idea what that is and how to correct it or adjust the time? If I hit the back arrow on my browser and then go there again the problem is gone.