upgraded from 4.7i to 4.8.6 and am hosed, help!

sross · January 29th, 2005, 07:39 AM

well, as far as I can tell it should have gone ok but looks bad, i have no vb3 integration anymore and errors on the top page: http://www.apug.org/gallery

Also I try to login as admin and get invalid administrator

I'm not having much luck searching the forums, can anyone help? thanks!

sross · January 29th, 2005, 03:27 PM

ok made a little progress, i configured my config inc file, but now i get this error:

Database not properly setup - unable to read settings table. Contact administrator.

I am not sure why it's saying this as I did run the upgrade script and it told me it was setup successfully, can anyone help? Getting desperate..

sross · January 29th, 2005, 04:04 PM

ok more progress, i did have errors on the upgrade script, it couldn't find my tables cause i did not have the right prefix in. so i corrected that and only got two errors after upgrade.php

Performing MySQL command: ALTER TABLE galleryusergroups ADD uplimit INT(5) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'uplimit'

Performing MySQL command: ALTER TABLE gallerycategories ADD ugnovote VARCHAR(255) NULL AFTER ugnopost ... Error: Duplicate column name 'ugnovote'

So, now I get my gallery page back with this error at the top:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/apug002/public_html/gallery/forums/vb3.php on line 316

As well as it tells me I am not a valid administrator

sross · January 29th, 2005, 04:24 PM

The error emailed to me by mysql:

An error was encountered during execution of the query:

SELECT
groupid,cpaccess,modaccess,diskspace,uploadsize,uplimit,uploads,comments,editpho,editposts,useralbums,reqmod,canassign
FROM galleryusergroups WHERE groupid='2' LIMIT 1

The query returned with an errorcode of:

Unknown column 'canassign' in 'field list'

sross · January 29th, 2005, 05:15 PM

Still not having much luck, I am afraid this is all way over my head. How can I pay you guys to fix this for me? The gallery is a big part of my site and it's been down 2 days already. Thanks

Chuck S · January 29th, 2005, 06:38 PM

Looks to me like you did not run all the upgrades

http://www.apug.org/gallery/

YOUR GALLERY SHOULD BE FIXED. Make sure to set under forum settings forum style to yes

sross · January 29th, 2005, 11:01 PM

omega thank you!!! especially on the weekend!

paprman · February 17th, 2005, 02:56 PM

This is my second try at upgrading from 4.86c to the newest version. After the frist attempt I just reloaded my back up scripts and everthing worked.

After running the upgrade script I got this error:

Quote:

Database not properly setup - unable to read settings table. Contact administrator.

Any suggestions or would you be willing to fix my problem for a fee ?

Henry
webmaster@htslifestyle.com

Chuck S · February 17th, 2005, 05:52 PM

if you got the database not set up properly looks to me like you changed your table prefix and you should not have. That is set in your config-inc.php and you can look and correct that.

As far as upgrading you run every applicable upgrade from your last version to the latest.

By the way there was never a 4.86C so I take it you meant 4.8C so you would run the 482upgrade

paprman · February 17th, 2005, 10:31 PM

Quote:

Originally Posted by omegatron

if you got the database not set up properly looks to me like you changed your table prefix and you should not have. That is set in your config-inc.php and you can look and correct that.

Thanks, fixed the prefix (forgot to enter it).

Quote:

Originally Posted by omegatron

By the way there was never a 4.86C so I take it you meant 4.8C so you would run the 482upgrade

Sorry, I got the version numbers mixed up. I was upgrading to 4.86.

Now have new problem can't get into the admin page for photopost. Program keeps asking me to log in, then loops back and ask again. Once again you help is very much appreciated.

Henry

Chuck S · February 17th, 2005, 11:13 PM

depends on your integration but thats a cookie setting. You may need to view the settings table in database viewer and set the cookie settings correctly.

what integration?

paprman · February 18th, 2005, 07:16 AM

My integration is VB3, the settings for vb3 are as follows:

Path to cookies: /
Cookie Domain: (blank)

I am not sure where to edit the settings for photopost in PHP MyAdmin. The only cookie setting I found was for 'SMF Cookie Name' ?

Chuck S · February 18th, 2005, 07:19 AM

As I replied to your PM

In your settings table entry 172 cookie prefix should be bb if using vb3 default