Errors on Upgrade

am-fs · March 17th, 2009, 07:34 PM

Errors on Upgrade
vb3.5.4 to 3.8.1
vbgallery from 1.01 to 2.4.3

Code:

Content visible to verified customers only.

Before I upgraded, i had 15 adv_ tables and 19 pp_ tables
after i ran the install script I had 15 adv_tables & 17 pp_tables.
for some reason it dropped pp_stats and pp_users, so i dropped them back into the database.

Currently have the plunin disabled for gallery, forum works find no problesm

Enable plugin, forum home goes to a blank white page, same for gallery.

Disable forumhome addon, forum work but clicking on members name, blank white page.

I retested this on localhost and have the following errors:
Gallery Index
Fatal error: Cannot use string offset as an array in C:\xampp\htdocs\gallery\gallery_global.php on line 256

Forum Index
Fatal error: Cannot use string offset as an array in C:\xampp\htdocs\forum\includes\vbgallery\forumhome_complete.php on line 87

If you view gallery as a guest, it has the gallery version listed as v2.0.0 (Gallery is turned off)

Also had another DB error but reinstall templates and plugins and disabling product took this error away.

Code:

Content visible to verified customers only.

any help would be great
am-fs

Chuck S · March 18th, 2009, 10:03 AM

Your errors are because the gallery has not been upgraded as you report it says 2.0 in your database.

You can send more pertinent information like admin url login and ftp information to the contact link in our header for assistance.

am-fs · March 20th, 2009, 11:06 PM

Thanks Chuck for getting my gallery back online

But now i found 2 new DB Errors

This one when browsing a category

Code:

Content visible to verified customers only.

This one, clicking on the link for gallery stats on the forum home.

Code:

Content visible to verified customers only.

Also product list 2.4.3 but gallery says 2.4.2
Logins are the same if needed.
Thanks
am-fs

am-fs · March 24th, 2009, 06:33 PM

Any Idea on this?

Have tried to upgrade to 2.5 on a localhost/test site but it starts from the beginning again.
ppgal_setting already exists, if I try again and says im running current version.

also see 3 set of tables for the gallery
adv_gal
pp_gal
pp_

do i need all of those?

Have gallery plugin disabled because every new member there is an error.

Code:

Content visible to verified customers only.

Thanks
am-fs

Chuck S · March 26th, 2009, 10:50 AM

That SQL is not from vbgallery.

Thats an SQL from the vbulletin albums feature

vbGallery does NOT have an album table

Chuck S · March 26th, 2009, 10:53 AM

Now on post 3 ppicount error.

On line 94 of stats.php the line should read

Code:

Content visible to verified customers only.

Chuck S · March 26th, 2009, 10:55 AM

Now on post 3 title clean field try running these two queries against your database to see what exists or does not. Remember to add in any table prefix if there is one.

Code:

Content visible to verified customers only.

am-fs · March 27th, 2009, 06:18 PM

Thanks Chuck

as for the album errors, it was fixed by disabling the user setting (Can change profile block settings) in the usercp.
so there might be something conflicting.

also post 3 ppicount error is still there but i not going to use that option.

I did get 2.5 beta up but it did not update my DB table, says 2.42 when it should be 2.5, should i manually set that to 2.5?

I do have the flash loader option.

Thanks again
am-fs

Chuck S · March 27th, 2009, 06:55 PM

You can redownload the files to update plugin version dates its not a big deal.

The file edit I posted should solve the ppicount thing.