vBulletin Product SQL Import

[browneyadz]

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:


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]

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

[browneyadz]

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


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

[ozzy47]

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

[browneyadz]

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

Please refer above.

[ozzy47]

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

[browneyadz]

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

[ozzy47]

Link to that mod please.

[browneyadz]

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

[ozzy47]

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]

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]

That one only adds a row to the existing table.

[browneyadz]

This wasn't executed.

[ozzy47]

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

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

Now on the line:
$config['Database']['tableprefix'] = '';

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

[browneyadz]

I believe we are not using a global table prefix

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

[ozzy47]

Hmmm, I am at a loss then. :(

[browneyadz]

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

If anyone else could assist that would be excellent.

[vbresults]

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

Forgot to censor one of the url's :p

[kh99]

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]

Forgot to censor one of the url's :p

Yeah, I know.

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?

The database user has full permissions

[squidsk]

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]

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]

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]

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.


Would this be the issue for every product then ;S

[ozzy47]

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

[browneyadz]

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]

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

[browneyadz]

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]

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]

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]

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]

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

[Lynne]

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.