vb.org Archive - vBulletin Product SQL Import

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - vBulletin Product SQL Import (https://vborg.vbsupport.ru/showthread.php?t=313857)

browneyadz

08-21-2014 10:14 PM

vBulletin Product SQL Import

Whilst trying to import several plugins into my vBulletin 3.8.7, it has come to my attention that regardless of the success of installation message it seems the tables are not created / altered within the database. It seems all the configuration file is correct? Could anyone provide a solution for this issue as I'm not sure if its global. I've tried searching around but I can't find an answer.

Take Yet Another Award System for example;
I get a database error:

Quote:

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT award.*, award_cat.award_cat_title
FROM award AS award
LEFT JOIN award_cat AS award_cat USING (award_cat_id)

ORDER BY award_cat.award_cat_displayorder,award.award_displ ayorder;

Any support would be excellent.

Thanks

ozzy47

08-21-2014 10:15 PM

Is that the full error? Check your server error logs to find the full error.

browneyadz

08-21-2014 10:16 PM

I get the following displayed to me, as the import of sql was unsuccessfull.

https://vborg.vbsupport.ru/external/2014/08/21.png

ozzy47

08-21-2014 10:24 PM

If you don't know where those are, you will have to ask your host. :)

browneyadz

08-21-2014 10:25 PM

I just checked, and there are no recorded error logs for the issue.

Please refer above.

ozzy47

08-21-2014 10:26 PM

I still can not see the full error from that image. :)

browneyadz

08-21-2014 10:28 PM

https://vborg.vbsupport.ru/external/2014/08/20.png

ozzy47

08-21-2014 10:30 PM

Link to that mod please.

browneyadz

08-21-2014 10:31 PM

<a href="https://vborg.vbsupport.ru/showthread.php?t=196244" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=196244</a>

ozzy47

08-21-2014 10:37 PM

Try installing this mod, and see if it actually installs, this should tell us if it is the mod, or the site.

https://vborg.vbsupport.ru/showthread.php?t=288136

browneyadz

08-21-2014 10:38 PM

Im going to try this now, some plugins that don't require sql add perfectly. Just ones that require new tables, or alterations.

____________________________________________

Edit:

Again, the sql didn't alter the database.

ozzy47

08-21-2014 10:41 PM

That one only adds a row to the existing table.

browneyadz

08-21-2014 10:44 PM

This wasn't executed.

ozzy47

08-21-2014 10:45 PM

Ok, open your includes/config.php file and look for this:

Code:

    //    ****** TABLE PREFIX ******

    //    Prefix that your vBulletin tables have in the database.

$config['Database']['tableprefix'] = '';

Now on the line:

Code:

$config['Database']['tableprefix'] = '';

Make sure you have the correct table prefix you are using set in-between the ''

browneyadz

08-21-2014 10:50 PM

I believe we are not using a global table prefix

https://vborg.vbsupport.ru/external/2014/08/19.png

ozzy47

08-21-2014 10:59 PM

Hmmm, I am at a loss then. :(

browneyadz

08-21-2014 11:00 PM

Not sure as to what the problem could be to be honest! :{

If anyone else could assist that would be excellent.

vbresults

08-22-2014 04:30 AM

Quote:

Originally Posted by browneyadz (Post 2512270)

I get the following displayed to me, as the import of sql was unsuccessfull.

Forgot to censor one of the url's :p

kh99	08-22-2014 09:02 AM

I don't know a lot about database administration, but I think it could be that your database user doesn't have the right permissions. Have you tried creating a table yourself (such as through phpMyAdmin) using the same db user info as you have in your config.php?

browneyadz

08-22-2014 02:53 PM

Quote:

Originally Posted by vbresults (Post 2512300)

Forgot to censor one of the url's :p

Yeah, I know.

Quote:

Originally Posted by kh99 (Post 2512310)

The database user has full permissions

squidsk

08-22-2014 04:38 PM

What version of mysql are you running?

You can try altering the product xml by replacing all instance of:

TYPE=MyISAM

with

ENGINE=MyISAM

Then remove the product and re-import.

browneyadz

08-22-2014 06:12 PM

Quote:

Originally Posted by squidsk (Post 2512359)

What version of mysql are you running?

You can try altering the product xml by replacing all instance of:

TYPE=MyISAM

with

ENGINE=MyISAM

Then remove the product and re-import.

https://vborg.vbsupport.ru/external/2014/08/17.png

squidsk

08-22-2014 06:31 PM

You'll need to do those replacements from my previous post in the product xml in order to install the product. Type=XXX is no longer supported as MySQL syntax. You should see errors about those lines in your mysql error log.

browneyadz

08-22-2014 06:37 PM

Quote:

Originally Posted by squidsk (Post 2512369)

Would this be the issue for every product then ;S

ozzy47

08-22-2014 06:46 PM

I don't think so, as the DBTech one I had you try only alters a existing table, not add a new one.

browneyadz

08-22-2014 07:35 PM

Quote:

Originally Posted by ozzy47 (Post 2512371)

I don't think so, as the DBTech one I had you try only alters a existing table, not add a new one.

DBTech User Tagging system won't install also.

ozzy47

08-22-2014 08:06 PM

Right, so it has no relation to the type or engine.

browneyadz

08-22-2014 08:07 PM

Quote:

Originally Posted by ozzy47 (Post 2512380)

Right, so it has no relation to the type or engine.

Really have no clue as to what the issue could be, I've checked prefixes, user permissions, repaired tables, chmodded files. Nothing.

squidsk

08-22-2014 08:38 PM

Quote:

Originally Posted by browneyadz (Post 2512370)

Would this be the issue for every product then ;S

Not for every product be definitely for ones that have that in their install code.

ozzy47

08-22-2014 08:42 PM

Quote:

Originally Posted by squidsk (Post 2512386)

Not for every product be definitely for ones that have that in their install code.

Right, and some do not, and it still can not be installed, which leads me to believe it is a issue with the host.

browneyadz

08-22-2014 08:50 PM

Quote:

Originally Posted by ozzy47 (Post 2512387)

Right, and some do not, and it still can not be installed, which leads me to believe it is a issue with the host.

Again, I have changed hosts. No difference.

squidsk

08-22-2014 09:30 PM

Manually turn off all other products you have installed through admincp and then try installing a failed one again.

Lynne

08-23-2014 01:15 AM

When you set up your mysql user, were you sure to grant them ALL access to the database? If they don't have all permissions, or your host won't allow you to grant all permissions, then modifications that alter databases may not install. You should check your mysql error log.

All times are GMT. The time now is 05:04 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01298 seconds Memory Usage 1,779KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (11)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (33)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: