Welcome to Geeklog, Anonymous Friday, December 06 2024 @ 05:34 am EST
Geeklog Forums
Error updating from 1.3.9.sr1
Smafty
Anonymous
I just updated a site to the new Geeklog here 1.4.0.sr.1 and after I finish I get the message
An SQL error has occurred. Please see error.log for details.
When I hit my error log I see this:
Sat Mar 4 23:07:28 2006 - 1054: Unknown column 'status' in 'field list'. SQL in question: SELECT status FROM gl_users WHERE uid=2
Sat Mar 4 23:09:41 2006 - 1054: Unknown column 'status' in 'field list'. SQL in question: SELECT status FROM gl_users WHERE uid=2
I made a mistake somewhere, any ideas where?
An SQL error has occurred. Please see error.log for details.
When I hit my error log I see this:
Sat Mar 4 23:07:28 2006 - 1054: Unknown column 'status' in 'field list'. SQL in question: SELECT status FROM gl_users WHERE uid=2
Sat Mar 4 23:09:41 2006 - 1054: Unknown column 'status' in 'field list'. SQL in question: SELECT status FROM gl_users WHERE uid=2
I made a mistake somewhere, any ideas where?
8
6
Quote
Smafty
Anonymous
I couldn't get to the installer script.
From what I can tell every new file has been uploaded.
J.
From what I can tell every new file has been uploaded.
J.
7
6
Quote
Smafty
Anonymous
You will have to run the install script to update your database.
bye, Dirk
It's not giving me the option to.
The error message reads when accessing from my browser (Firefox 1.0 same error in Safari)
An SQL error has occurred. Please see error.log for details.
The same error log issues pop up.
6
4
Quote
Smafty
Anonymous
Quote by Dirk: Not sure what you're doing there. Enter the full URL to the install script directly, i.e. http://www.example.com/admin/install/install.php
bye, Dirk
bye, Dirk
From that it gives me an error page saying it can't find the page can't be found.
7
6
Quote
Smafty
Anonymous
Quote by Dirk: You should of course replace "example.com" with the proper domain name ...
bye, Dirk
bye, Dirk
Obviously.
http://jprsol.com/admin/install/install.php
This was the URL I was using.
6
4
Quote
Smafty
Anonymous
Quote by Dirk: What's the proper URL for your existing Geeklog site? It's obviously not http://jprsol.com
Attach admin/install/install.php to your URL and you should get to the install script.
bye, Dirk
Attach admin/install/install.php to your URL and you should get to the install script.
bye, Dirk
I get from there, (after a fix in the config.php) to getting this error
Sun 05 Mar 2006 03:11:40 MST - 1054: Unknown column 'archive_flag' in 'where clause'. SQL in question: SELECT tid FROM gl_topics WHERE archive_flag='1'
10
5
Quote
Smafty
Anonymous
Quote by Dirk: That sounds like you still didn't run the install script to upgrade the database ...
bye, Dirk
bye, Dirk
I ran the test and the check said it's Ok but I still get the error.
8
6
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
The test script will only check permissions of a few files and directories. It does not perform any checks on the database.
The error message you quoted above indicates that you are trying to run Geeklog off of a database that has not been upgraded yet. So you either didn't run the install script, or it failed, or you're running it on the wrong database.
Since I obviously can't see what you're doing from here, please retrace your steps or provide more information ...
bye, Dirk
The error message you quoted above indicates that you are trying to run Geeklog off of a database that has not been upgraded yet. So you either didn't run the install script, or it failed, or you're running it on the wrong database.
Since I obviously can't see what you're doing from here, please retrace your steps or provide more information ...
bye, Dirk
7
5
Quote
Smafty
Anonymous
I put this in
http://www.mywebpage.com/geeklog/public_html/admin/install/install.php
I switched it to upgrade Database.
I selected my version of Geeklog from the menu and it from there it said it was successful.
But still nothing.
http://www.mywebpage.com/geeklog/public_html/admin/install/install.php
I switched it to upgrade Database.
I selected my version of Geeklog from the menu and it from there it said it was successful.
But still nothing.
6
10
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Smafty: I selected my version of Geeklog from the menu
Which was? 1.3.9?
Quote by Smafty: But still nothing.
Meaning what exactly?
The 'archive_flag' it was complaining about in the error message you quoted above was introduced in 1.3.10. So if you're upgrading from 1.3.9, selected 1.3.9 as the version you're coming from in the install script, and it was successful, then you shouldn't get that error message any longer.
bye, Dirk
7
6
Quote
Smafty
Anonymous
That's the error I'm getting so what I'm going to do is start from scratch.
10
5
Quote
All times are EST. The time is now 05:34 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content