Database error. Urgent!

Pedro! · November 1st, 2006, 01:58 PM

I'm installing for the first time. Running vB 3.6.2, downloaded the appropriate zip, extracted, uploaded, CHMODed, just ran the install script and got this error:

Quote:

Code:

Content visible to verified customers only.

Database error
The iSketchForum.net database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.isketchforum.net home page, then try to open another page.
Click the Back button to try another link.

The www.isketchforum.net forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

In addition my inbox is rapidly filling up with an vBulletin DB error emails.

Getting the same error on every page of my site.

Zachariah · November 1st, 2006, 02:20 PM

Perhaps you uploaded the php files in Binary format and not ASCII ?
-
Also you do not have the gallery installed yet.

- Edit:
forums/includes/init.php

- Find:

Code:

Content visible to verified customers only.

and hash out the line.

replace:

Code:

Content visible to verified customers only.

Save and upload. After you install the gallery remove the hash marks.

Pedro! · November 1st, 2006, 03:29 PM

That didn't work. Would it have anything to do with the fact my admin directory is not the default vBulletin name?

Okay, found out a detailed error message in the source of the page.

Code:

Content visible to verified customers only.

That should help.

Zachariah · November 1st, 2006, 05:53 PM

The "language.phrasegroup_adv_gallery" is added when the XML product is imported.

If you have access to AdminCP, reimport the product for the gallery.
- it is located in the Zip file. forums/admincp/product-ppvbgallery.xml

Pedro! · November 2nd, 2006, 03:23 AM

I can't access my admin CP, is there another way to import it?

Zachariah · November 2nd, 2006, 09:14 AM

shoot me some FTP access and an account that has AdminCP access via PM
- I'll take a look.

Pedro! · November 4th, 2006, 06:08 AM

No worries dude, turns out after post #2 I dragged the changed init.php file to my root instead of my includes directory. Oops! I did it right, imported the XML file, ran the install script (had to refresh the images bit a few times :/) and it's working like clockwork now.

It might be an idea changing the installation instructions to tell people to import the XML before running the install script.

Thanks for your help

mlucek · November 7th, 2006, 05:44 PM

OK, I had the exact same problem. Commented out the line in init.php as instructed, got thru the install process, but now when I go to the control panel, this is what I see when the control panel is opened. Upper left where the vbGallery links should be, is just junk. The 2nd pic is when you click on that missing link - opens another frame containing the same as the initial frame.

Looks like phrase/link href is missing ?? Do I need to reimport the .xml file ?

This was a fresh install on VB3.6.2 which was also newly installed.

This happens whether or not the 'functions_gallery_store.php' line in init.php is included or not.

Zachariah · November 7th, 2006, 06:00 PM

Quote:

Originally Posted by mlucek

OK, I had the exact same problem. Commented out the line in init.php as instructed, got thru the install process, but now when I go to the control panel, this is what I see when the control panel is opened. Upper left where the vbGallery links should be, is just junk. The 2nd pic is when you click on that missing link - opens another frame containing the same as the initial frame.

Looks like phrase/link href is missing ?? Do I need to reimport the .xml file ?

This was a fresh install on VB3.6.2 which was also newly installed.

This happens whether or not the 'functions_gallery_store.php' line in init.php is included or not.

There is an XML file (product) in the build.
/forums/admincp/product-ppvbgallery.xml

Plugins & Products => Manage Products => [Add/Import Product]

Allow Overwrite [x]

This will reinstall: templates / phrases / plugins

mlucek · November 7th, 2006, 07:12 PM

Tried that, exactly the same result as in the pictures above. i.e. nothing visible changed.

Any more ideas ?

If not, I'll just remove and reinstall it and see if it does it again.

mlucek · November 8th, 2006, 05:14 PM

OK, did a clean, fresh, plain vanilla install of VB3.6.3/vbgallery 2.1 - EXACT same error as above. Also tried reimporting the XML file with the same results. Here's the HTML snippet from the VB control panel entry:

Code:

Content visible to verified customers only.

As can be seen in the bolded code, the text of the buttons and href is either empty or trash.

What are the phrases that are supposed to be in there - id's of the phrase so I can look up what's missing and/or why it's missing.

Am I the only one with this problem ??

mlucek · November 8th, 2006, 05:36 PM

More info:

I can access the gallery control panel from the direct link :

.../forums/admincp/vba_gallery_admin.php

So looks like something is hosed up with the main control panel phrases/settings/href's/whatever.

Zachariah · November 8th, 2006, 06:28 PM

well the main controle pannel menu in the AdminCP is created by forums\includes\xml\cpnav_vbagallery.xml using the same phrases as vba_gallery_admin.php.

Try reuploading that file in ASCII format.

mlucek · November 8th, 2006, 06:44 PM

Zachariah - cpnav_vbagallery.xml - that's appears to just be the control panel nav dropdown menu entries.

Where is the vbgallery main control panel entry created and what are the phrases used there ?

Looks like neither the control panel menu element and the dropdown are being created.

Zachariah · November 8th, 2006, 07:06 PM

I am a little thick in understanding mlucek

.
- Shoot me some FTP access and an account w/ admincp access via PM. I might be able to solve whats going on and report back

.

mlucek · November 11th, 2006, 02:42 AM

Zach - I believe I found the root of the install problem I was having. The VBulletin plugins are turned off after a fresh install of VB is done. I believe vbGallery needs the plugin system to be enabled ? Correct me if I'm wrong.

I did a fresh VB install, enabled the plugin manager, then did a fresh vbGallery install (except for the init.php - did that afterwards) and it seems to be ok - image paths were wrong, but think the installer corrected those.

If the VB plugin system needs to be enable for the vbGallery install (I'm now pretty sure it needs to be), I suggest putting in a step to enable the plugin system before the install proceeds. vbAdvanced installer does have this install step to make sure plugins are enabled, so shouldn't be to hard to replicate that !!

Mike

Zachariah · November 11th, 2006, 09:29 AM

Quote:

Originally Posted by mlucek

Zach - I believe I found the root of the install problem I was having. The VBulletin plugins are turned off after a fresh install of VB is done. I believe vbGallery needs the plugin system to be enabled ? Correct me if I'm wrong.

I did a fresh VB install, enabled the plugin manager, then did a fresh vbGallery install (except for the init.php - did that afterwards) and it seems to be ok - image paths were wrong, but think the installer corrected those.

If the VB plugin system needs to be enable for the vbGallery install (I'm now pretty sure it needs to be), I suggest putting in a step to enable the plugin system before the install proceeds. vbAdvanced installer does have this install step to make sure plugins are enabled, so shouldn't be to hard to replicate that !!

Mike

Enable plugin manager on install.
- Thanks for the tip