Step 2 System Checks Fatal error: Call to undefined function: validateconnection() in /hermes

bburnett

Joined: 2008-09-03
Posts: 77
Posted: Mon, 2009-07-06 23:01

I tried to upgrade from 2.2 to 2.3 and I received this error message on STEP 2 System Checks

Fatal error: Call to undefined function: validateconnection() in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/upgrade/steps/SystemChecksStep.class on line 701

How do I resolve this issue?

Thanks, Peace,
bburnett

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Mon, 2009-07-06 23:14

Well normally I'd give you this:
FAQ: How can I make sure that my installation files are all intact?

But since you can't really get there. I'd try re-uploading the Gallery files. I think something might have gotten corrupt on transfer.

If that still doesn't work, post a link to phpinfo, this link explains how:
FAQ: What information is required when I ask for help in the forums?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 02:25

I tried re-uploading all 3 versions (Basic, Typical and Full) and I received the same error message. Fatal error: Call to undefined function: validateconnection() in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/upgrade/steps/SystemChecksStep.class on line 701

After uploading do I browse directly to www.thebucketdatabase.com/photos/upgrade OR do I browse directly to the install folder ( www.thebucketdatabase.com/photos/install )

I too think this is simple fix rather than re-uploading 3000+ photos. Your help is sincerely appreciated.

Is this the info you are looking for?:

Gallery version = 2.2.6 core 1.2.0.8
PHP version = 4.4.7 cgi
Webserver = Apache
Database = mysqlt 5.0.45-log, lock.system=flock
Toolkits = Dcraw, Exif, Getid3, ImageMagick, LinkItemToolkit, ArchiveUpload, SquareThumb, Thumbnail, Gd
Acceleration = none, none
Operating system = Linux boscgi1703.eigbox.net 2.6.24.7 #1 SMP Fri Sep 5 15:14:39 EDT 2008 i686
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8 (.NET CLR 3.5.30729)
Rows in GalleryAccessMap table = 433
Rows in GalleryAccessSubscriberMap table = 3291
Rows in GalleryUser table = 6
Rows in GalleryItem table = 3285
Rows in GalleryAlbumItem table = 141
Rows in GalleryCacheMap table = 0

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-07 02:51

You'd go to the upgrader.

I found the problem. Double, triple, quadruple check the permissions on the files and make sure that the upload is overwriting files. Right now you do have old files that did not get overwritten. The function that the error message is referring to should exist in /modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 2203. That file on your install does not have that, it's the old version before those changes were put into place.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 03:13

Thank You
I will triple check that my upload is overwriting the older files and let you know what happens.

Thanks Again, Peace,
bburnett

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 17:15

It seems to be working now that I used Core FTP LE 2.1 to upload the new folders to the server. Previously I used FTP Commander 8.0 and it was not over writing the older files.

I do have another question though;
"when I get to Step 2 System Checks the upgrader asks me to run the script to delete unnecessary files, Can I proceed with the upgrade and delete them manually after the upgrade is complete? OR do I need to run the script/delete them before proceeding to Step 3 Database Backup?"

Thanks Again for all your help. Peace,
bburnett

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-07 17:17

It doesn't ask you to run the script. It's just telling you there are old files and gives you a link to download a script that you can run from your server, if you have SSH access to delete the files. You can ignore them if you want.

Do the database backup, but make sure you do a database backup from your control panel or using the instructions to create a dump of the database. I'm finding the XML backups to be pretty useless.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 19:56

I can not get past Step 4 Core Upgrade, and I receive the following error message:

The server encountered an unexpected condition which prevented it from fulfilling the request.
The script had an error or it did not produce any output. If there was an error, you should be able to see it in the error log.

I will post the error log ASAP.

Thanks,
bb

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 20:04

Are these 2 issues the cause of my problem?

PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/AlbumDB.php on line 192 PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/AlbumDB.php on line 192 PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/AlbumDB.php on line 192 PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/Album.php on line 1750 /classes/Album.php on line 1750

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-07 20:14

Is your g2data directory located outside of your gallery directory?

If so, try this. BACKUP BACKUP BACKUP

Backup your database, backup your g2data, backup your G2 install (less important, but helpful if we need to revert back)

Rename your gallery directory. Upload an all new G2 2.3 install. Copy your .htaccess and config.php into the "new" directory from your old install. Then try again.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 20:26

I'm a firm believer in backing everything up, especially after the last crash I had w/ 2500 pics.

I backed up my Database and g2data,

so I rename my current gallery directory, and create a NEW directory for my fresh 2.3 install? but once the new 2.3 is installed, how do I migrate the pictures over from the old directory to the new 2.3 fresh install directory?

Thanks,
bb

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-07 20:35

with your config.php and your g2data and your database all of your data should be intact. We're just trying to do the upgrade with a fresh set of files.

So copy your old config.php and .htaccess into your new "install" and run through the upgrader. It should be picking up your existing DB and g2data from config.php and see this as an upgrade. Actually it should send you straight to the upgrader the second you browse to your site with the new install files along with your old config.php and .htaccess files in place if you haven't successfully upgraded to 2.3 yet.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 20:43

tech support said my error occurred in:
modules/core/classes/galleryplatform

she said to check the scripting withing this folder, so I reinstalled both Unix and WinNT files, and I received the same message.

Should I proceed with your instructions above or try a new Unix file?

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-07 20:48

Post a link to phpinfo so I can take a look at your php environment, this link explains how:
FAQ: What information is required when I ask for help in the forums?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 20:50

Is this the info you wanted?

Gallery version = 2.2.6 core 1.2.0.8
PHP version = 4.4.7 cgi
Webserver = Apache
Database = mysqlt 5.0.45-log, lock.system=flock
Toolkits = Dcraw, Exif, Getid3, ImageMagick, LinkItemToolkit, ArchiveUpload, SquareThumb, Thumbnail, Gd
Acceleration = none, none
Operating system = Linux boscgi1703.eigbox.net 2.6.24.7 #1 SMP Fri Sep 5 15:14:39 EDT 2008 i686
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8 (.NET CLR 3.5.30729)
Rows in GalleryAccessMap table = 433
Rows in GalleryAccessSubscriberMap table = 3291
Rows in GalleryUser table = 6
Rows in GalleryItem table = 3285
Rows in GalleryAlbumItem table = 141
Rows in GalleryCacheMap table = 0

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-07 20:55

A link to phpinfo, it's the 3rd bullet point on the link I provided above.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 21:04
nivekiam wrote:
A link to phpinfo, it's the 3rd bullet point on the link I provided above.

so after I upload this file what is my next step?

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-07 21:16

Post the URL so I can click on it :)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 21:33
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-07 22:11

Hmmm, nothing is sticking out to me there. Are you able to perform a completely fresh install of 2.3? New install location /gallery_test (for example) new g2data, new database?

Is there any possibility you could provide me access to your server and login details? I'm willing to take a closer look. It just seems odd to me that this isn't working.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Tue, 2009-07-07 22:35

I created a new folder photos2 for my fresh install, but my FTP keeps crapping out and my hosting company swears the problem is on my end.

I'll send you a PM with some info ASAP.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Wed, 2009-07-08 01:48
bburnett wrote:
Are these 2 issues the cause of my problem?

PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/AlbumDB.php on line 192 PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/AlbumDB.php on line 192 PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/AlbumDB.php on line 192 PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/Album.php on line 1750 /classes/Album.php on line 1750

Just pointing out that classes/AlbumDB.php is a G1 file so don't know how that shows up on a g2 install.

Dave

_____________________________________________
Blog & G2 || floridave - Gallery Team

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Wed, 2009-07-08 02:19
floridave wrote:
bburnett wrote:
Are these 2 issues the cause of my problem?

PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/AlbumDB.php on line 192 PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/AlbumDB.php on line 192 PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/AlbumDB.php on line 192 PHP Fatal error: Call to a member function on a non-object in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos/classes/Album.php on line 1750 /classes/Album.php on line 1750

Just pointing out that classes/AlbumDB.php is a G1 file so don't know how that shows up on a g2 install.

Dave

_____________________________________________
Blog & G2 || floridave - Gallery Team

I don't know either, but that is output of the error log. I don't think I ever had g1 installed?
I'm not going to work on it until I hear back from nivekiam. I don't want to be in there working while he is trying to resolve this issue.

Peace,
bburnett

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-07-08 06:59

o.k. I'm giving up. The following is NOT a bash on you, I'm just frustrated.

This is why I never host my sites with low-end, cheap, crappy hosts that don't offer SSH access. The servers are slow, the web server and the database servers are just plain out right overloaded.

So here's the state things are in.

I have a fresh, full, all language install of 2.3 in your photos2 directory. I've copied (I think, all of your g2data over there). However, without SSH access and your host's ultra crappy control panel, I can't tell if it's all there. It also didn't set permissions on that g2data directory correctly. So you are not the owner, in fact 0 is the owner. You'll need to contact your host to have them

chown -R <YourUserName> g2data and make the group something like www or 15010, what ever is appropriate for their setup as I saw both.

While you're at it, again since the control panel outright sucks you can't set the permissions recursively either, so ask them to:
chmod -R 777 g2data or make sure that the directories and files are writable by the webserver.

Get a backup, a real backup, of your database. I couldn't figure out how to do that. Their "help" file didn't match up with their interface. I tried in FF and IE. Again without SSH access this seems harder than it should be.

What I spent the last 4.5 hours doing (well I was able to walk away and do other stuff while files were transferring) I could have done in 5 or 10 minutes or probably 20 on those slow, overloaded server with SSH access.

Right now you have tons of extra files;
2 copies of g2data, one complete (I think) copy of gallery. I didn't complete the install because I was trying to install using a copy of your existing g2data and your database.

I also tried doing an upgrade of your current /photos directory and when Gallery tries to update the core, after about 5 minutes of churning it timesout. Again, I'm pretty sure (100% positive) it's the database server. Takes a long time just to complete step 2. Which takes a fraction of a second on my server.

If it were my site, I'd back up everything, EVERYTHING and find another host, leaving everything running until I have the new place setup and then transfer name servers. Or see how much stuff your hosts support people will do for you since I'm sure they have command line access and can get stuff done lickity split.

You can try doing a "new" install with your existing data.

go to photos2/ and run through the installer. Point it to your photos/g2data directory and to your current database. MAKE SURE YOU GET BACKUPS of those BEFORE you do anything, test them make sure they are good BACKUPS. You've been warned. :)

I didn't want to do that because I can't seem to figure out how to get a backup of your database.

Example, on my server, I was able to install 4 completely separate installs of Gallery (same database, different tables) in 15 minutes. That's what SSH access can help get you :)

If you have any questions or need any clarification or if you think I broke something more than it already was, just let me know. I still want to help, but I can't get so hands on again. I'm pretty sure nothing is any worse than it was and if I could figure out how to make and restore some backups so I felt comfortable I'd test out a few things.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Wed, 2009-07-08 15:27

Thanks nivekiam for all your help :) I sincerely appreciate it. You confirmed what I was thinking for almost a year now, my hosting companies servers are slow as snails! I knew it should not take HOURS to upload a new install of G2.3

My hosting company does the usual "phone company tricks" like "everything is fine on our end" and "it must be the settings on your software", "can you send a us a snapshot of your FTP software settings" I told them yesterday when my yearly contract is up I will be looking for a new hosting company due to their cut and paste responses from tech support and extremely slow servers.

No worries I don't think you broke anything, you can't break what is already broken, haha :)

Thanks Again for all your help! You Rule!!!

I will try the fresh install later this morning (more coffee is needed) and if I run into any trouble, I'll just start from scratch. We have about 5 or 6 people in our group that can re-upload photos in batches.

I'll post my install results after I take the leap ;)

Thanks, Peace,
bburnett

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-07-08 15:44
Quote:
I knew it should not take HOURS to upload a new install of G2.3

If you have SSH access it's as simple as typing wget URL_FOR_FILE_TO_GET then unzip install (after creating a database)

If you are going to go the fresh install route and not care about comments or view counts or anything like that, here's what I'd do in your situation.

Install G2 using the minimal install:
http://codex.gallery2.org/Gallery2:Download#Packages

Well you could also use the Full package I uploaded, but do NOT activate all the plugins, do the bare minimum. If ImageMagick works on your server, then do just ImageMagick and Add Items (upload from local server), nothing else. Get it up and running then activate other plugins you really need and leave all others uninstalled. In fact, anything you are not using, I'd go into your /modules directory and delete

Then since you installed the Add Items plugin, you can set that to point to your existing g2data/albums directory and import photos from there versus re-uploading.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Wed, 2009-07-08 18:17
nivekiam wrote:

Well you could also use the Full package I uploaded, but do NOT activate all the plugins, do the bare minimum. If ImageMagick works on your server, then do just ImageMagick and Add Items (upload from local server), nothing else. Get it up and running then activate other plugins you really need and leave all others uninstalled. In fact, anything you are not using, I'd go into your /modules directory and delete

Then since you installed the Add Items plugin, you can set that to point to your existing g2data/albums directory and import photos from there versus re-uploading.

I will do what you recommended above because ImageMagick does work, but should I rename the new directory folder from "photos2" to "photos" before beginning the installation process?

Thanks, Peace,
bb

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-07-08 18:31

On your server, without SSH access that will probably be easier if you want to keep Gallery in the same place. Do note, if you have images referenced in blogs, linking directly to images those are all broken if you start over.

If you were using URL Rewrite, then the links to the photos pages should still work just fine and not break, so long as you keep the same names. However, if you weren't using URL Rewrite, then those are broken as well.

If you have any questions or problems about what to do with your g2data directories, just us know.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Wed, 2009-07-08 18:51

no blogs and I believe I was using URL re-write

I was wondering can I rename the new directory from "photos2" to "photos" before beginning the installation process without causing more problems? or should I bite the bullet and leave the directories as is?
(this is so I do not have to change numerous links on my other sites that point towards the "photos" directory)

Thanks, Peace,
bb

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-07-08 18:53
Quote:
I was wondering can I rename the new directory from "photos2" to "photos" before beginning the installation process without causing more problems? or should I bite the bullet and leave the directories as is?

Yes, I'd probably do that now, making sure I backup everything, current photos with g2data and current database.

You can always change the location later, but it might be a huge pain at your host:
FAQ: How can I move my gallery installation from one folder to another?

FAQ: How can I move my storage folder to another path?

FAQ: How can I move my gallery installation from one server to another?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Wed, 2009-07-08 19:31

I'll back everything up (although it may take a while due to my hosting companies clogged servers and dropped FTP connections), and then I will rename the directories.
Then I will begin the new installation. Then I will import photos from the old install g2data/albums.

I will update this thread after its up and running.

Thanks Again For All Your Help, Peace,
bb

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Thu, 2009-07-09 20:19

What the hell am I doing wrong?

I cannot complete Step 5 Database Setup of a fresh install on "photos2"

I received the following error message:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'thebucke'@'boscgi1701.eigbox.net' (using password: YES) in /hermes/bosweb/web004/b44/sl.thebucke/public_html/photos2/lib/adodb/drivers/adodb-mysql.inc.php on line 365
thebucke.startlogicmysql.com: Access denied for user 'thebucke'@'boscgi1701.eigbox.net' (using password: YES)

(why does it say Access denied for user 'thebucke'@'boscgi1701.eigbox.net' (using password: YES)??? because I used my regular password )

Should I rename the old "photos" to something completely different, and then rename "photos2" as "photos" and then start as a fresh install?

BB

www.thebucketdatabase.com/photos2/phpinfo.php

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2009-07-09 20:22

That's the information for connecting to your database.

If you are going to use the old database (you can change table and column prefixes to not overwrite data) then just look in your old config.php in your photos directory and it's got all that information there.

IIRC, your database server (hostname) is not what you are using right now.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Thu, 2009-07-09 20:37

This thing reads like a freaking novel, haha
sorry I'm slowly losing it....

I renamed the old "photos" to something completely different, and then rename "photos2" as "photos" and then started as a fresh install. Here we go

oh boy Step 6
Gallery tables already exist in the database and the Gallery storage directory seems to be intact. Either choose to reuse the existing database tables and storage directory data or select a clean install to erase all existing data in the database and the storage directory.

I'm gonna click re use existing tables? Is that correct?

Continue to step 7 :)
coolness

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2009-07-09 20:51

Cool, finish the install?

Yeah, reuse if you have a backup, then you won't have to re-import everything. And you can test to make sure that's all going to work. That's what I wanted to do, but couldn't figure out how to get a reliable backup of the database.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Thu, 2009-07-09 20:57

nope never gets past core upgrade due to clogged servers

I'm going to make my hosting company fix "everything"

unless you want to take a crack at it?

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2009-07-09 21:06

I doubt you'll have much success with them, but you can try.

I would try one more time for a totally fresh install.

Download the Minimal, English Only package here: http://codex.gallery2.org/Gallery2:Download#Packages

Create a new database through your control panel

Don't reuse any database or g2data and start fresh. If you can't get that installed with just the absolute minimum then there is definitely something wrong with their servers. Otherwise, while their servers are overloaded, they may not just be able to activate all of those plugins at the same time, so the install is bombing out.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Thu, 2009-07-09 21:19

O.k. I know hosting companies do not provide any support for third party software, but I told them my problems in a trouble ticket regarding my FTP connection dropping and that in turn resulted in a botched Gallery upgrade.

I basically told them I cannot restore, install or upgrade due to their clogged servers and no SSH access, and if they do not restore it back to 2.2.6 or 2.3 by the end of the business week I will migrate my domain name to a different hosting company.

Once I get a Minimal Eng only package installed, and everything is up and running and my pics are back, where is the link on how to delete my g2 directory off my server. Thanks, Peace,bb

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2009-07-09 21:29

To delete g2:

Delete your gallery folder

Delete g2data
-this may require resetting permissions, see /lib/support for that

Delete the database
-double and triple check that it's the right database and that only gallery was using it.
-if other things were using it, then it's probably o.k. to leave it. If you really want to clean it up, be careful, but you should be able to delete the tables that gallery install was using. Again, double and triple check what you are doing.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Thu, 2009-07-09 23:45

Yea I'll probably just leave it.

In summary, basically, I did everything correctly right???, the upgrade was hosed due to my hosting companies slow/clogged servers and no SSH access???

Thanks Again for all your help,
BB

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Fri, 2009-07-10 00:05

As far as I can tell, yes. It's their system that makes it hard to do stuff.

I too had dropped SFTP connections and had to reconnect several times to get the install transferred.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Fri, 2009-07-10 22:45

Tech Support Response:

Dear bburnett,
Thank you for contacting support.

I'm sorry for your obvious frustration here. From what you describe it appears that, probably due to the size of the gallery, the upgrade process is not able to complete. On shared hosting, we do limit the maximum execution time for both scripts and database queries; this is necessary to prevent a script from potentially locking up all resources, preventing their use by other accounts. Unfortunately, this can not be disabled for your account. If the upgrade script or database query can not complete in the time allowed, they will time out.

You should also note that we do not provide support for the application once it has been initially installed, and so are very limited in the help we can provide with upgrades such as this. If the upgrade process has failed, the only solution we can suggest would be to install a fresh copy of Gallery 2.2.5 [the only version we currently offer], and then port your existing contents in to that. You should be able to install that through Gallery Central. If you experience difficulty there, please reply with the installation information required:

Gallery title:
Admin Username:
Admin Password:
Admin Email:
Domain / URL
Installation Directory

If you need any folder in your account 'rolled back', we would be happy to do so. At the present time, we have system backups dated June 28th and July 5th, and can restore any folders in your account from these. We'd just need to know the name of the folder and the backup from which you want the folder restored.

Thank You,

Technical Support

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Just thought I would post a conclusion to the story...
so I'm going to have them restore it back to June 28th. I'm tired of dealing with this.....

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Fri, 2009-07-10 22:57

Would be nice to know if they have the DB backups from that time that they say they have backups for.
No harm in getting them to rollback the DB and the gallery2 folder along with the g2data folder. If they can't roolback the DB from the same timeframe then it is pointless I suspect.

I feel your pain.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Sat, 2009-07-11 03:32

I'm back up and running!

http://thebucketdatabase.com/photos/main.php

How do I submit my URL/site to appear on the right hand side of this forum in the "random image" section?
and
Is Gallery 3.0 beta stable enough to just post video clips? or should I stick with 2.3 for video clips (and MP3's)
I'm leaving "photos" directory as is.

Thanks Again to nivekiam (and floridave) for all your help.

Peace,
bburnett

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sat, 2009-07-11 03:59
Quote:
How do I submit my URL/site to appear on the right hand side of this forum in the "random image" section?

http://gallery.menalto.com/index.php?q=gallery&g2_view=linksubmit.LinkSubmit

Quote:
Is Gallery 3.0 beta stable enough to just post video clips?

It is beta. the definition of beta is:
'It is the prototype of the software that is released to the public. Beta testing allows the software to undergo usability testing with users who provide feedback, so that any malfunctions these users find in the software can be reported to the developers and fixed. Beta software can be unstable and could cause crashes or data loss.'
So it is up to you.

Glad you are up and running!

Dave

_____________________________________________
Blog & G2 || floridave - Gallery Team

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Sat, 2009-07-11 15:16

I thought maybe the beta version would be stable enough, but it looks like it is really a beta version. No worries I'll just use 2.3 for my audio and video clips.

Well I didn't think my Gallery would magically work after they rolled it back, and it doesn't.

My new problem:

When I go to login, it says "Type the word appearing in the picture"

well the field is there to enter the word, but there is no CAPTCHA picture to see.

What is the easiest procedure resolve this issue?

Thanks, Peace,
bburnett

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sat, 2009-07-11 16:21
 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Sat, 2009-07-11 16:44

myPHP Admin page times out due to their slow servers. I requested that my hosting company to fix this too!
I will definitely be switching hosting companies, because this is pure B.S.!

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Sat, 2009-07-11 16:52

I finally got to the g2 PluginMap in myPHP Admin database, so basically I want to change the Captcha module from 1 (being active) to 0 (to deactivate it).

Is that correct?

thank, peace,
bburnett

 
bburnett

Joined: 2008-09-03
Posts: 77
Posted: Sat, 2009-07-11 20:44

I finally was able to access myPHP Admin, and I ran the SQL commands located here
http://codex.gallery2.org/Gallery2:FAQ#How_can_I_deactivate_a_module_when_I_am_unable_to_login.3F

and it WORKS! Yea!!!

Nivekiam and Floridave I owe you guys a beer. If you guys are ever in So. Cal, give me a shout!

Thanks Again for all your guys help, I sincerely appreciate it :)

"Onward through the fog"

Peace,
bburnett

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sun, 2009-07-12 05:39

Glad you got it working. As for the beer... we would both appreciate if you could:
[img]http://gallery.menalto.com/themes/gmc/images/gallery_donate.png[/img]

Cheers!
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team