vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Major Additions - DTO Garage - free garage features for all your members (vB 3.8.X) (https://vborg.vbsupport.ru/showthread.php?t=216529)

mferguson 06-29-2009 01:06 PM

Quote:

Originally Posted by devilsown (Post 1838665)
should i get a blank page for this page?
http://www.grandprixforums.net/dto_g...?do=viewgarage

Yes. If there is no garage id specified there is nothing for the viewgarage state to display.

How are you running into this issue? Is this a link in one of your pop-up menus found in a postbit?

Thanks!

Mark

mferguson 06-29-2009 01:18 PM

Quote:

Originally Posted by Kyrasis6 (Post 1838722)
Crap, my server doesn't have php 5.0 or MySQL 5.0 installed. Any chance of increased compatability with older versions (4.0?) in the near future? I guess I'll have to start bugging my web host to upgrade his servers since we're on first name basis, lol.

Since our ShowCase and Vendor Tools products are heavily built on object-oriented technology our functionality requires features only found PHP 5. Also, since many hosts have already migrated to PHP5 and MySQL 5 we have done all our testing against those versions as well as vB 3.6.X through vB 3.8.X.

I will say that, while not tested, our Clubs, Garage, and Garage Plus products should work with PHP 4.X and MySQL 4.X. I can't guarantee them to operate on these versions but there aren't technical dependencies on 5.X versions of these. The only thing preventing installation is the dependencies specified in the product.xml during product install.

How many of you are still on PHP4 and MySQL 4.X? Also, do you know what your host's upgrade plans are for these or are you on a dedicated box where upgrades to these components are not mandated?

Thanks!

Mark

mferguson 06-29-2009 01:20 PM

Quote:

Originally Posted by MrNase (Post 1838920)
You shouldn't but I get a blank page as well. I tried it on two different servers.

Can you tell me where this is being encountered? There is no garage id specified when the viewgarage state is being called. Since there is no id the software has no idea what it needs to display so no page is rendered.

Thanks for any information you can share so I can assist in resolving this issue for you!

Mark

oly51 06-29-2009 03:39 PM

Quote:

Originally Posted by mferguson (Post 1839541)
Can you send me a PM with the URL where this error is being created? Obviously in my haste to provide a garage link plugin fix I missed something when trying to code this from a campground in Colorado :)

Thanks!

Mark

The error went away when I reloaded the original product XML file. I added a garage to my profile and the garage link is not appearing in postbit. I'll PM the link.

mferguson 06-29-2009 03:58 PM

Quote:

Originally Posted by oly51 (Post 1839647)
The error went away when I reloaded the original product XML file. I added a garage to my profile and the garage link is not appearing in postbit. I'll PM the link.

I've PMd you back with additional information. In the meantime restoring the original product XML will reinstall the original postbit plugin that is preventing the link from being displayed but you won't receive any SQL errors.

I'll work with you to determine the cause of the SQL error when the plugin patch is installed and then post an update of the patch and package to this thread when we have the issue resolved.

Thanks!

Mark

Kolbi 06-29-2009 04:10 PM

That would be very nice :)
Have I understood it right, that your fast fixed plugin is the cause of the mysql error?
Then I can in the meantime reimport the old plugin and wait until the bug is fixed :)

mferguson 06-29-2009 04:34 PM

Quote:

Originally Posted by Kolbi (Post 1839667)
That would be very nice :)
Have I understood it right, that your fast fixed plugin is the cause of the mysql error?
Then I can in the meantime reimport the old plugin and wait until the bug is fixed :)

That is correct. In my testing of the new plugin I did not encounter this bug so there is some type of issue with different site configurations. Before you reimport can you send me a screen capture of a thread where you are seeing the MySQL errors. If you could provide a capture (or multiple captures) of the entire thread that would be most helpful in debugging and resolving this issue.

To reload the old plugin just reinstall the original product xml file using the overwrite option. Make sure that this option is used otherwise you will not be able to reload the plugin. Please do not uninstall and then reinstall the product as it will remove all the data you may have entered in your Garages.

Please note that by reinstalling the original product xml you will not see the garage link in the postbit until we resolve this issue. You will, however, be able to use the manage garage functions found in UserCP.

Best regards,

Mark

Kolbi 06-29-2009 05:30 PM

Quote:

Please note that by reinstalling the original product xml you will not see the garage link in the postbit until we resolve this issue. You will, however, be able to use the manage garage functions found in UserCP.
That doesn?t matter now :) Therefore I?m waiting for the update :)

This was shown, then I got the MySQL failure:
Code:

Datenbankfehler in vBulletin 3.8.3:

Invalid SQL:
SELECT * FROM DTO_garage_vehicle WHERE userid =  AND display='1';

MySQL-Fehler  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND display='1'' at line 1
Fehler-Nr.    : 1064
Fehler-Zeit  : Friday, 26.06.2009 @ 20:49:09
Datum        : Friday, 26.06.2009 @ 20:49:12
Skript        : http://www.2-wheel-planet.de/showthread.php?t=357
Referrer      :
IP-Adresse    :
Benutzername  : Kolbi
Klassenname  :
MySQL-Version : 5.0.67-log


Raptor 06-29-2009 06:15 PM

Quote:

Originally Posted by Kolbi (Post 1839728)
That doesn?t matter now :) Therefore I?m waiting for the update :)

This was shown, then I got the MySQL failure:
Code:

Datenbankfehler in vBulletin 3.8.3:
 
Invalid SQL:
SELECT * FROM DTO_garage_vehicle WHERE userid =  AND display='1';
 
MySQL-Fehler  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND display='1'' at line 1
Fehler-Nr.    : 1064
Fehler-Zeit  : Friday, 26.06.2009 @ 20:49:09
Datum        : Friday, 26.06.2009 @ 20:49:12
Skript        : http://www.2-wheel-planet.de/showthread.php?t=357
Referrer      :
IP-Adresse    :
Benutzername  : Kolbi
Klassenname  :
MySQL-Version : 5.0.67-log


im getting this exact same error when certain posts are accessed on the forum. Apart from this it works great. I await an update.

mferguson 06-29-2009 08:33 PM

Quote:

Originally Posted by Raptor (Post 1839756)
im getting this exact same error when certain posts are accessed on the forum. Apart from this it works great. I await an update.

Raptor, can you PM me with some additional information? I've been unable to reproduce the problem on our local test machine using vb 3.8.3 so I suspect it may be related to usergroup permissions and/or an issue we identified some time ago that is related to certain versions of vBSEO. If you could provide the following information via PM it will likely help to quickly diagnose the issue and provide a fix.
  1. URL of a thread where this is happening on your site
  2. Are there are any errors shown when rendering the page?
    If not are the errors just being delivered via email?
  3. For the users in the above thread - are there any usergroup or permissions differences between the users
  4. Are you using vBSEO and if so what version?

Thanks for your assistance!

Best regards,

Mark


All times are GMT. The time now is 12:50 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01365 seconds
  • Memory Usage 1,757KB
  • 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
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete