Geeklog Forums

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)

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.

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

bye, Dirk

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?

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

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.

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

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.

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

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

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.

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!