Welcome to Geeklog, Anonymous Saturday, October 01 2022 @ 11:28 pm EDT

Geeklog Forums

1.4.1 to 1.5 MySQL field issues


Chase

Anonymous
HI guys

After getting a sucess message on install. I went to the home page and admin page and got the usuall render message.

Log shows some fields are either changed, or changed and not being called properly by te plugins?..i think.
Please help.


Wed 18 Jun 2008 02:06:02 PKT - 1064: 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 '\' AND approved=1' at line 1. SQL in question: SELECT * FROM gl_advt_ads WHERE ad_id=133\' AND approved=1

Wed 18 Jun 2008 05:20:24 PKT - Media Gallery Error - Invalid album_id passed to album.php

Wed 18 Jun 2008 08:40:09 PKT - 1054: Unknown column 'category' in 'field list'. SQL in question: SELECT lid, category, date FROM gl_links WHERE (perm_anon >= 2)
 Quote

Chase

Anonymous
ok all issue vanished when i removed config.php from root folder.

now the public site is accessible.

when when i login as admin i still get similar issues.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by: Chase

Wed 18 Jun 2008 08:40:09 PKT - 1054: Unknown column 'category' in 'field list'. SQL in question: SELECT lid, category, date FROM gl_links WHERE (perm_anon >= 2)


Are you still getting this? Sounds like the database wasn't upgraded properly. Try again.

bye, Dirk
 Quote

chase

Anonymous
so what i did is

copied back my orginal DB

then ran the upgrade process
at this point my config.php is in the root folder.

but still getting this error.

Wed 18 Jun 2008 12:07:23 PKT - 1054: Unknown column 'category' in 'field list'. SQL in question: SELECT lid, category, date FROM gl_links WHERE (perm_anon >= 2)

And this time the install ended in
An SQL error has occurred. Please see error.log for details.

what to do?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by: chase

Wed 18 Jun 2008 12:07:23 PKT - 1054: Unknown column 'category' in 'field list'. SQL in question: SELECT lid, category, date FROM gl_links WHERE (perm_anon >= 2)


Actually, my original diagnosis was wrong - the database upgrade was successful. There is no field "category" in the gl_links table any more.

Looks like some of the files for the Links plugin have not been updated. Since you're getting an SQL error right on the success page, I'd say it's at least plugins/links/functions.inc that isn't up to date. But also check the other files.

bye, Dirk
 Quote

Chase

Anonymous
i could not find resolution to this

so i mannually disabled the links plugin from plugins table
and then ran the site, it worked. Wasted all day... should have done this earlier! :-)

BTW do let meknow if you you can suggest what i am doing wrong. (i did upload the links folders in plugin, pub_html and admin

Also where do i go about fixing the theme, right now i am back to using the professional theme.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
The only other thing I can think of is that you may have some add-ons on the site that try to access the Links plugin's data. Maybe a PHP block or a static page?

bye, Dirk
 Quote

Chase

Anonymous
still getting this error.

1054: Unknown column 'category' in 'field list'. SQL in question: SELECT lid, category, date FROM gl_links WHERE (perm_anon >= 2)

But strange thing is, site is working fine from user end, it is only the admin side where i am getting this error.
For anonymous user and logged in user(non-admin) site is working fine, links plugin included.

but unless i disable the plugin from from gl_plugin table i cant use any thing in login.


 Quote

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
Try disabling the other plugins - specifically glMenu if you have that installed (and it's not been updated).
Geeklog components by PortalParts -- www.portalparts.com
 Quote

Status: offline

geiss

Forum User
Full Member
Registered: 02/10/04
Posts: 176
Location:Boise, Idaho
Also where do i go about fixing the theme, right now i am back to using the professional theme.


We have created a list of template changes between 1.4.1 and glFusion 1.0.0 (based on Geeklog v1.5.0) in our wiki over at gl Labs. Perhaps they might be a helpful reference to you in making the changes to update your theme.

You can also look at using the Nouveau theme that is included with glFusion, or cordiste has released a 1.5.0 compatible theme called Colors as well. Finally, Ironmax is in process of upgrading some themes to 1.5.0 here.

Hope this helps!

Eric
Synergy - Stability - Style --- Visit us at glfusion.org
 Quote

Chase

Anonymous
i have narowed it down to gsmap function which i was calling from lib custom.
On the face of i cant see why it would crib and die.

but i removed that block and wolha...link section is working fine.

i will dig more to find out why.



 Quote

Chase

Anonymous
anyone who migrates to 1.5.0 from 1.4.1

and is using gsmap php_block
needs to change

at around line number 190 the field category to cid

and the migration will be complete.

Now why i was in so much grief, there is lesson to be learned for everyone.

I had 3 copy of the source now

1.4.0, 1.5.0 and the one running on production site.
1.5.0 did not have the custom directory (i had not put it there) and as result could not find it.

for some reason textpad which i use alot did not find the string i was looking for earlier.


anyway cheers now! Smile
 Quote

All times are EDT. The time is now 11:28 pm.

  • 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