Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 10:36 am EDT

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?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Did you run the install script (in upgrade mode)? Did you really upload all the new files?

bye, Dirk
 Quote

Smafty

Anonymous
I couldn't get to the installer script.

From what I can tell every new file has been uploaded.

J.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Smafty: I couldn't get to the installer script.

What do you mean by that?

You will have to run the install script to update your database.

bye, Dirk
 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.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 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


From that it gives me an error page saying it can't find the page can't be found.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
You should of course replace "example.com" with the proper domain name ...

bye, Dirk
 Quote

Smafty

Anonymous
Quote by Dirk: You should of course replace "example.com" with the proper domain name ...

bye, Dirk


Obviously.

http://jprsol.com/admin/install/install.php

This was the URL I was using.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 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

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'
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
That sounds like you still didn't run the install script to upgrade the database ...

bye, Dirk
 Quote

Smafty

Anonymous
Quote by Dirk: That sounds like you still didn't run the install script to upgrade the database ...

bye, Dirk


I ran the test and the check said it's Ok but I still get the error.
 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
 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.
 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
 Quote

Smafty

Anonymous
That's the error I'm getting so what I'm going to do is start from scratch.
 Quote

All times are EDT. The time is now 10:36 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