Welcome to Geeklog, Anonymous Thursday, December 26 2024 @ 08:26 am EST
Geeklog Forums
Database issues
Daniel
Anonymous
I just upgraded from 1.4.1 to 1.6.1. I'm noticing that my database is not always updating per my edits.
Question, concern, etc.
My newly updated database tables all prefix with gl_ (i.e. gl_users, gl_staticpage, gl_access, etc.) but here's the code from usersettings.php (after the upgrade).
$result = DB_query("SELECT fullname,cookietimeout,email,homepage,sig,emailstories,about,location,pgpkey,photo FROM {$_TABLES['users']},{$_TABLES['userprefs']},{$_TABLES['userinfo']} WHERE {$_TABLES['users']}.uid = {$_USER['uid']} AND {$_TABLES['userprefs']}.uid = {$_USER['uid']} AND {$_TABLES['userinfo']}.uid = {$_USER['uid']}");
$A = DB_fetchArray ($result);
Don't the two need to match? If so, how many other files do I need to look at?
I noticed this while trying to understand why I was unable to unclick the "Add To Menu:" item for static pages. I, also, saw this in the phpblock_affiliates - previously used.
Kickstart me, PLEASE!
:banghead:
7
6
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
'users' is only an index into the $_TABLES array. That entry then contains the actual table name, with the prefix. So that's just fine.
Are you using your old theme (from your previous 1.4.1 install)? If so, you need to update it. Use the Professional theme for now and try again.
bye, Dirk
Are you using your old theme (from your previous 1.4.1 install)? If so, you need to update it. Use the Professional theme for now and try again.
bye, Dirk
6
8
Quote
dwcondu
Anonymous
I am using the Professional theme.
I can go to the phpMyAdmin and make changes and they show up in GL editor (after a refresh) but not the other way around. I can delete the static page and recreate it and it shows both gone and re-inserted.
I see no error record in my server's log.
Another issue:
When I add the static page and can get the Add to Menu to toggle, The title appears in the menu slections at the top of the page. When I click on the title I get:
Access Denied
Access to this page is denied. Either the page has been moved/removed or you do not have sufficient permissions.
I have (at least, I thought I did) disable the Contribute and Forum from my site. The selections are still showing up along the top but not the right block.
Any other suggestions? Do I need to do an New Install?
TIA
4
5
Quote
dwcondu
Anonymous
Contribute went away after clicking on X under Theme cofiguration.
I'm sure most of these issue are caused by "Operator Error and Headspace (having way too much)."
I'm sure most of these issue are caused by "Operator Error and Headspace (having way too much)."
7
3
Quote
dwcondu
Anonymous
Interesting!
I went back to Theme Configuration and added the Forum selection. I then saved. All menu items went away except the top 3 (Search, Statistics and Directory). While the Forum showed up in the selections, it did not appear in the newly revised top menu selections. I then x'd it away. It is gone.
Maybe the program finally was able to synch everything up. Might have been a cache issue.
6
6
Quote
All times are EST. The time is now 08:26 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