Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 21 Aug 2014, 23:14
browneyadz browneyadz is offline
 
Join Date: Sep 2010
Real name: Adam Brown
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:

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_displayorder;
Any support would be excellent.

Thanks
Reply With Quote
  #2  
Old 21 Aug 2014, 23:15
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
Is that the full error? Check your server error logs to find the full error.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #3  
Old 21 Aug 2014, 23:16
browneyadz browneyadz is offline
 
Join Date: Sep 2010
Real name: Adam Brown
I get the following displayed to me, as the import of sql was unsuccessfull.



Last edited by browneyadz; 21 Aug 2014 at 23:24.
Reply With Quote
  #4  
Old 21 Aug 2014, 23:24
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
If you don't know where those are, you will have to ask your host.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #5  
Old 21 Aug 2014, 23:25
browneyadz browneyadz is offline
 
Join Date: Sep 2010
Real name: Adam Brown
I just checked, and there are no recorded error logs for the issue.

Please refer above.
Reply With Quote
  #6  
Old 21 Aug 2014, 23:26
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
I still can not see the full error from that image.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #7  
Old 21 Aug 2014, 23:28
browneyadz browneyadz is offline
 
Join Date: Sep 2010
Real name: Adam Brown
Reply With Quote
  #8  
Old 21 Aug 2014, 23:30
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
Link to that mod please.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #9  
Old 21 Aug 2014, 23:31
browneyadz browneyadz is offline
 
Join Date: Sep 2010
Real name: Adam Brown
http://www.vbulletin.org/forum/showthread.php?t=196244
Reply With Quote
  #10  
Old 21 Aug 2014, 23:37
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
Try installing this mod, and see if it actually installs, this should tell us if it is the mod, or the site.

http://www.vbulletin.org/forum/showthread.php?t=288136
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #11  
Old 21 Aug 2014, 23:38
browneyadz browneyadz is offline
 
Join Date: Sep 2010
Real name: Adam Brown
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.
Reply With Quote
  #12  
Old 21 Aug 2014, 23:41
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
That one only adds a row to the existing table.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #13  
Old 21 Aug 2014, 23:44
browneyadz browneyadz is offline
 
Join Date: Sep 2010
Real name: Adam Brown
This wasn't executed.
Reply With Quote
  #14  
Old 21 Aug 2014, 23:45
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
Ok, open your includes/config.php file and look for this:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Now on the line:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Make sure you have the correct table prefix you are using set in-between the ''
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #15  
Old 21 Aug 2014, 23:50
browneyadz browneyadz is offline
 
Join Date: Sep 2010
Real name: Adam Brown
I believe we are not using a global table prefix

Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 04:54.

Layout Options | Width: Wide Color: