vb.org Archive - Major Additions - DTO Garage - free garage features for all your members (vB 3.8.X)

Page 3 of 13

Show 40 post(s) from this thread on one page

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)

gnatster

06-27-2009 01:26 AM

Quote:

Originally Posted by mferguson (Post 1837588)

PS - I'm currently traveling and will do my best to follow up to any reply you make while I still have Internet access.

It may be until Sunday until Mark has access, possibly Saturday evening.

Thanks for your patience on this, we will have it resolved.

Kolbi

06-27-2009 07:09 AM

Some problem like me, but the increbible thing is, that in some thread the garage link is there :)
Only in some threads there is the bug. :)

devilsown

06-28-2009 02:57 AM

should i get a blank page for this page?
http://www.grandprixforums.net/dto_g...?do=viewgarage

Kyrasis6

06-28-2009 07:50 AM

Quote:

PHP 5.X or later (compiled with GD support) and MySQL 5.X or later is required.

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.

kirkmkiv

06-28-2009 12:34 PM

Great job, I like where this is headed as I run automotive forums.

MrNase

06-28-2009 04:02 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

You shouldn't but I get a blank page as well. I tried it on two different servers.

mferguson

06-29-2009 12:43 PM

Quote:

Originally Posted by Kolbi (Post 1837927)

Is only the } at the end of the code different?

Now working perfectly.
Demo: http://www.2-wheel-planet.de/aprilia....html#post8452

Sorry for the delay in replying to this and other recent posts. I've just returned from a vacation with my family and have not had Internet access for the past two days.

As for the code change there was a permission check that had apparently crept in during a product file update from our source control system. This was from our Garage Plus product. I removed this permission check and delivered this in the plugin download above.

Again, I apologize for the delay in responding to the additional questions posted.

Best regards,

Mark

mferguson

06-29-2009 12:54 PM

Quote:

Originally Posted by Kolbi (Post 1837961)

I have a little question. In the template "dto_garage_popup_menu"

Code:

<if condition="$use_username_in_link">

<phrase 1="$userinfo[username]">$vbphrase[xs_garage] </phrase>

<else />

Garage 

</if>

I tried this an always "Garage" appears.
The fact that you can?t edit the phrase $vbphrase[xs_garage] (it?s always ?{1}?s Garage) doesn?t makes it senseless?
Wouldn?t it better then instead of Garage would appear {1}?s Garage in the Postbit?

Code:

<if condition="$use_username_in_link">

<phrase 1="$userinfo[username]">$vbphrase[xs_garage] </phrase>

</if>

Doesn?t works? Why?
but

Code:

<if condition="$use_username_in_link">

<phrase 1="$userinfo[username]">$vbphrase[xs_garage] </phrase>

<else />

<phrase 1="$userinfo[username]">$vbphrase[xs_garage] </phrase>

</if>

Does what I want. :) It displays the phrase for example Kolbi?s Garage

Or don?t I understand this code...

$dto_garage_popup_menu is actually a variable that, when referenced, in a template contains the needed html to render the pop-up menu. Currently the $use_username_in_link is not being set as it is for future expansion hence why it wasn't displaying as you would like. The reason I had selected the "Garage" link approach in postbit was because the post was already "owned" by the user so I felt that using the user's name next to the link so that it would look like "Mark's Garage" would be redundant. Also, since we found that there are often long usernames on sites we didn't want to create a visual problem with rendering a long username inside of the postbit since it was already displayed once.

Hope this helps shed a little light on the reason behind the madness :D

Best regards,

Mark

mferguson

06-29-2009 01:01 PM

Quote:

Originally Posted by Kolbi (Post 1837977)

Is there a comment function or a rate system in DTO Garage?
I think this would be very nice.

I get an MySQL failure message:

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

We chose to not develop commenting and reviews since we wanted to gather site owner requirements for these features. As you can imagine these features could easily be abused by members/visitors by way of artificially driving up/down a garage rating, inappropriate comments relative to your site guidelines, etc. Given this I wanted to gather input on how owners would like to see these features managed and calculated (ratings) so that they minimize admin monitoring and provide something useful to the members.

As for the SQL error are you still receiving these? It looks like the above might have been displayed in rendering a Garage pop-up menu.

Thanks!

Mark

mferguson

06-29-2009 01:04 PM

Quote:

Originally Posted by oly51 (Post 1838150)

I'm getting the following dB error after I applied the postbit fix. It goes away when I disable DTO Garage.

Code:

Database error in vBulletin 3.8.2:



Invalid SQL:

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



MySQL Error   : 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

Error Number  : 1064

Request Date  : Friday, June 26th 2009 @ 08:39:40 PM

Error Date    : Friday, June 26th 2009 @ 08:39:40 PM

Script        : http://www.XXXXXXX.com/forums/showthread.php?t=9750

Referrer      : 

IP Address    : 

Username      : 

Classname     : vB_Database

MySQL Version : 5.0.67-community

Edit: I re-imported the original XML file and DTO garage works without the dB error. But there is no garage link in the postbit.

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

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)

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)

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 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.

URL of a thread where this is happening on your site
Are there are any errors shown when rendering the page?
If not are the errors just being delivered via email?
For the users in the above thread - are there any usergroup or permissions differences between the users
Are you using vBSEO and if so what version?

Thanks for your assistance!

Best regards,

Mark

mferguson

06-30-2009 07:48 PM

For those that are experiencing the SQL error after installing the plugin-patch posted can you tell me what version of vBSEO you are using?

In looking at oly51's information he was running vBEO 3.2 which has a problem in one of its plugins that prevents a vBulletin variable (userinfo) from being shared with postbit plugins. This is an issue I identified some time ago and worked with the vBSEO team to resolve.

Here is a description of the problem and how to resolve it if you are using versions of vBSEO earlier than 3.3.0 Gold. Please note that the issue was fixed in 3.3.0 Gold but exists in all 3.3.0 release candidates and previous versions.

Best regards,

Mark

Kolbi

06-30-2009 07:53 PM

I?m using vBSEO 3.3.0 Gold :)
But I have this SQL failure?!?

mferguson

06-30-2009 08:08 PM

Can you check the vBSEO plugin called "vBSEO Precache Postbits" and see if the following code is present?

PHP Code:


		
			
global $vbseo_gcache;

$vbseo_gcache['user'][$post['userid']] = array(
'userid'=>$post['userid'],
'username'=>$post['username']
);

If it is then let me know and we'll need to figure out a way to debug this issue. I've been unable to reproduce this issue myself and suspect that if it isn't the vBSEO issue that I'm aware of that it is related to usergroups that the users belong to? At a minimum the error being thrown indicates that $userinfo is being overwritten or not set up correctly thereby preventing the userid of the post owner from being passed to our code correctly.

Thanks!

Mark

oly51

06-30-2009 09:37 PM

I upgraded to vBSEO 3.3.0 Gold and re-added the temp XML fix and the garage link now shows up with no SQL errors.

mferguson

06-30-2009 09:43 PM

Quote:

Originally Posted by oly51 (Post 1840403)

I upgraded to vBSEO 3.3.0 Gold and re-added the temp XML fix and the garage link now shows up with no SQL errors.

Excellent. Please give garage creation, image uploading, postbit popup menu and user profile display a try to insure that everything is working correctly.

Thank you for the update!

Best regards,

Mark

oly51

07-01-2009 01:44 AM

The Mysql error is back. I reverted back to the original XML and they went away.

One common thing I noticed in two of the threads the error came from was that they contained a post by a "guest" who is not listed in any usergroup.

mferguson

07-01-2009 02:33 AM

OK...this was the information I was looking for and does not have user information associated with it. I can resolve this fairly easily.

Question though...why are guest's allowed to post without registering on the site? It seems this would result in massive amounts of spamming and not a configuration that I've ever run into before.

Thanks again for the missing piece of the puzzle. Please note that while I can resolve this issue the issues relative to vBSEO prior to 3.3.0 Gold will still prevent the garage link from displaying.

Let me work up a patch and I'll get that uploaded as soon as possible.

Mark

oly51

07-01-2009 09:31 AM

Mark - I applied the fix you forwarded and it cleared up the MySQL error. The garage link is showing in the postbit.

It is an unusual situation. Guests cannot post on my forums but there are a couple of old threads where the posters user info did not transfer when I migrated to vB and they showed up as a "guest". The search spiders must have picked them up.

Thanks for your help and quick responses.

Kolbi

07-01-2009 11:38 AM

Quote:

Originally Posted by mferguson (Post 1840359)

Can you check the vBSEO plugin called "vBSEO Precache Postbits" and see if the following code is present?

PHP Code:


		
			
global $vbseo_gcache;



$vbseo_gcache['user'][$post['userid']] = array(

'userid'=>$post['userid'],

'username'=>$post['username']

);

This is my plugin code:

PHP Code:


		
			
global $vbseo_gcache;



$vbseo_gcache['user'][$post['userid']] = array(

'userid'=>$post['userid'],

'username'=>$post['username']

);

It?s the same. A MySQL failure is caused by a visitor and the same by me (admin).

Kolbi

07-01-2009 11:41 AM

Quote:

Originally Posted by mferguson (Post 1840511)

Question though...why are guest's allowed to post without registering on the site? It seems this would result in massive amounts of spamming and not a configuration that I've ever run into before.

This could be the problem I had, too. Link: http://www.2-wheel-planet.de/vorstel....html#post2230 That caused the issue, I think.

I don?t allow guest to post, but I had deleted a user and then the name "guest" is shown.

mferguson

07-01-2009 01:35 PM

Quote:

Originally Posted by Kolbi (Post 1840687)

Kolbi - last night oly51 mentioned this guest issue and I sent him a patch to test if this was the cause of the issue. It was and I've reuploaded a new plugin patch for the postbit linking should resolve the issue for you.

Can you install the patch and let me know if it resolves the issues you were experiencing? If so, please confirm and I'll include this in the general distribution.

After this we'll move on to addressing the timing of a version that will support the various requests for language translations.

Thanks!

Mark

Kolbi

07-01-2009 02:02 PM

Okay I?m testing your new fix.

The first test is without any issue. Perhaps it works now correctly.
I?m still watching...

In the meantime I have translatet my Garage for me own :) Translated the templates and the phrases :)

But I?m waiting for the next version and then I support the translation :)

mferguson

07-01-2009 02:28 PM

Quote:

Originally Posted by Kolbi (Post 1840751)

Thanks for the update and I'm glad you have customized the product for your needs. I should have an update in the next couple of days on the what will be in the next release and when it can be expected. I'm working with our team to evaluate what's needed and the time required to complete the work.

Let me know if you experience any additional problems. Thanks!

Mark

Kolbi

07-01-2009 07:20 PM

I got a new MySQL issue:

PHP Code:


		
			
Datenbankfehler in vBulletin 3.8.3:

Invalid SQL:
INSERT INTO DTO_garage_image (
                vehicle_id,
                userid, 
                caption, 
                showinsections, 
                display_order, 
                time_added) 
                VALUES (
                '1003',            
                '918',
                '',
                'main', 
                10, 
                NOW() );

MySQL-Fehler  : Table 'DTO_garage_image' doesn't exist
Fehler-Nr.    : 1146
Fehler-Zeit   : Wednesday, 01.07.2009 @ 22:19:11
Datum         : Wednesday, 01.07.2009 @ 22:19:14
Skript        : http://www.2-wheel-planet.de/dto_garage.php?do=savevehicle
Referrer      : http://www.2-wheel-planet.de/dto_garage.php?do=add
IP-Adresse    : 
Benutzername  : Syntax92
Klassenname   : 
MySQL-Version :

The issue is now caused, if a user wants to add / edit a vehicle in the garage.

mferguson

07-01-2009 08:39 PM

Are you using table prefixes with vBulletin? For example does your user table in vBulletin called vb_user?

Quote:

Originally Posted by Kolbi (Post 1840943)

I got a new MySQL issue:

PHP Code:


		
			
Datenbankfehler in vBulletin 3.8.3:



Invalid SQL:

INSERT INTO DTO_garage_image (

                vehicle_id,

                userid, 

                caption, 

                showinsections, 

                display_order, 

                time_added) 

                VALUES (

                '1003',            

                '918',

                '',

                'main', 

                10, 

                NOW() );



MySQL-Fehler  : Table 'DTO_garage_image' doesn't exist

Fehler-Nr.    : 1146

Fehler-Zeit   : Wednesday, 01.07.2009 @ 22:19:11

Datum         : Wednesday, 01.07.2009 @ 22:19:14

Skript        : http://www.2-wheel-planet.de/dto_garage.php?do=savevehicle

Referrer      : http://www.2-wheel-planet.de/dto_garage.php?do=add

IP-Adresse    : 

Benutzername  : Syntax92

Klassenname   : 

MySQL-Version :

The issue is now caused, if a user wants to add / edit a vehicle in the garage.

bugzy

07-01-2009 11:10 PM

is everything stored locally within VBulletin database and server?

meaning, the garage info/images are not stored outside of the webserver itself?

gnatster

07-01-2009 11:43 PM

The garage info is stored in rows added to your current DB.

The images are stored down the /images/dto_garage/users/ path.

mferguson

07-01-2009 11:54 PM

To be more precise our products add additional tables, needed for our products, into the current database that is used for vBulletin. These are added during the product file installation and removed if the product are uninstalled.

As for images they are stored in URL accessible directories under your forum installation.

We do not store any data or files, such as images, on other servers. The only exception being our help documentation which is managed and served from our servers so that we can easily update it and tie it to product versions easily.

Hope that helps!

Mark

pericolosogr

07-02-2009 01:17 AM

So after following your installation there was a conlfict! I had to disable UserCP Icons for the garage links to appear in users control panel!

Should i have some garage links in postbit or postbit legacy? Cause i don't!

I have to make it work now with UserCP Icons and it would be perfect! Even though i'd like to link it with a postbit field i've created where a user puts his type of vehicle!

Thanx for this great mod!
I'll see how its going and maybe in the future i'll upgrade to plus :)

mferguson

07-02-2009 02:09 AM

Quote:

Originally Posted by pericolosogr (Post 1841121)

I'm not sure I fully understand what you mean by a conflict with UserCP icons. You should see the following when viewing UserCP as a user that is logged in:

https://vborg.vbsupport.ru/external/2009/07/51.png

If for some reason you do not see this be sure to double check the installation information in our documentation.

As for the postbit link be sure to view this post as there was an issue identified and a patch has been provided. This should insure that when viewing threads the postbit should display a link similar to the following:

https://vborg.vbsupport.ru/external/2009/07/52.png

Please note that the above is shown using postbit_legacy. Using postbit should display as follows:

https://vborg.vbsupport.ru/external/2009/07/53.png

If you still have problems after going through the above please contact me via PM and I'll assist further.

Best regards,

Mark

All times are GMT. The time now is 09:50 AM.

Page 3 of 13

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01779 seconds Memory Usage 1,921KB 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 (7)bbcode_code_printable (5)bbcode_php_printable (23)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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
Messages: