vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Add-On Releases - VB Pro Garage Timeslips (https://vborg.vbsupport.ru/showthread.php?t=236888)

KTP 08-15-2012 07:43 PM

my table is xxx_vb4
i had done a fresh install of vb 4.2.0 so its not from an upgrade, i dont know if that matters

i remember having vhoist on a previous forum and loved it, guessing this is the same but for vb4.x

Dylanblitz 08-19-2012 08:02 AM

Quote:

Originally Posted by KTP (Post 2357228)
my table is xxx_vb4
i had done a fresh install of vb 4.2.0 so its not from an upgrade, i dont know if that matters

i remember having vhoist on a previous forum and loved it, guessing this is the same but for vb4.x

Do you mean your database or your prefix is xxx_vb4?
I'm still not sure what would be causing that problem. I checked the code and there's not an extra _ in there. There's only 2 places where that query would be running.

Do you see the table garage_user_vehicle in your database?

ssoc 08-28-2012 01:11 AM

1 Attachment(s)
You may remember a while back, I posted a bug report here: https://vborg.vbsupport.ru/showpost....&postcount=785

I fixed the profile that was showing the error at the time, but that was clearly a temp fix. I never got to the bottom of what actually caused it to happen as I'm reluctant to edit any of the core plugin files.

Anyway, a couple of months on and it's happened again. This time to three users.
Not sure if this is just coincidence, but two out of the three users currently have " (quote) signs in their garage titles. See below:

Attachment 140807

Attachment 140806

It's possible that the other user did at some stage too, so perhaps this is what's causing this problem to crop up? Just a suggestion.

Anyway hopefully you can find out what the issue is and rectify it in your next update.


-----------------------------

In the meantime, anyone else having this problem; it's quite time consuming but here's how to repair each user:

1. Goes without saying.. backup the database first!
2. Login to PhpMyAdmin and locate the 'Userfield' table.

Some important notes: You'll find the next steps easier if you sort them by 'user id'. Remember, 'userid' is just that - the forum user id. This is different from the garage id, which you'll need to change in a later step.

To find the 'user id', hover the users name on the forums and the user id is listed at the end of the URL.

To find the 'garage id', go to that users garage and look in your browser address bar. The number at the end of the URL is the garage ID.

3. First open up a user who has a garage, and does NOT have the error displaying on the front end, in a new tab (by clicking 'edit').
Now scroll to the bottom and you'll see some code like this:

Attachment 140804

^This is good code.. how it should look. However every users' code is a little different, since they have different garage ID's, garage names, and obviously different car images (in this case, the thumbnail that appears when you click the 'vehicles' drop-down link from the users postbit).

4. Highlight, right click, and 'copy' that good code.
5. Now open another user in phpmyadmin (one who's got the error on the front end).. again, by opening in a new tab clicking the 'edit' link. Scroll to the bottom and you'll see 'bad code', like so:

Attachment 140803


6. Now delete that bad code and paste the good code in its place.
7. We then need to edit three things, as pointed out in this pic:

Attachment 140805

Here's how to get them:

The garage ID - as I described earlier in this post.
The thumbnail url - go to the users garage, and the image that's under their username is the one which is used as the thumbnail, so open it in a new tab and copy the URL from the browser address bar. You don't need the first part of it, just from images/ ...onwards.
The garage title - get this from the users garage. It's at the top.

8. Double check the code you're able to save and make sure you're editing the correct user
9. Click save

Now check the front end to make sure you've done it correctly. If you have, give yourself a pat on the head :up:

Dylanblitz 08-31-2012 04:33 AM

Did you check the user profile field and increase the size on it? It defaults to 100 but you need to have it quite a bit larger to hold all the data. The problem usually happens when you modify the user for some reason inside the ACP. It saves all fields and crops the text down to the field limit.

ssoc 08-31-2012 06:18 AM

1 Attachment(s)
Quote:

Originally Posted by Dylanblitz (Post 2361399)
Did you check the user profile field and increase the size on it? It defaults to 100 but you need to have it quite a bit larger to hold all the data. The problem usually happens when you modify the user for some reason inside the ACP. It saves all fields and crops the text down to the field limit.


Hi Dylan,

Which one is it using (or do I change the limit elsewhere)?

Attachment 140849

Thanks

Dylanblitz 08-31-2012 04:21 PM

Quote:

Originally Posted by ssoc (Post 2361411)
Hi Dylan,

Which one is it using (or do I change the limit elsewhere)?

Attachment 140849

Thanks

It's the field43 one. Edit that and check the length

ssoc 08-31-2012 04:43 PM

1 Attachment(s)
Quote:

Originally Posted by Dylanblitz (Post 2361503)
It's the field43 one. Edit that and check the length

It looks to already be set to 250 (this hasn't been edited).. I don't see any that are defaulted to 100?

Or do you mean the one that's set to 25?

Attachment 140874

Dylanblitz 08-31-2012 06:23 PM

Quote:

Originally Posted by ssoc (Post 2361509)
It looks to already be set to 250 (this hasn't been edited).. I don't see any that are defaulted to 100?

Or do you mean the one that's set to 25?

Attachment 140874

Where it says
Max length of allowed user input
I would change that to something larger, like 10000.
Then edit a users record that you know has a dropdown and see if their dropdown gets screwed up after. Might be a good idea to copy the data from that field out first in phpmyadmin so you can paste it back in :)

ssoc 08-31-2012 07:07 PM

1 Attachment(s)
Quote:

Originally Posted by Dylanblitz (Post 2361533)
Where it says
Max length of allowed user input
I would change that to something larger, like 10000.
Then edit a users record that you know has a dropdown and see if their dropdown gets screwed up after. Might be a good idea to copy the data from that field out first in phpmyadmin so you can paste it back in :)

Unable to edit it

Attachment 140884

Dylanblitz 09-01-2012 01:51 AM

Quote:

Originally Posted by ssoc (Post 2361544)
Unable to edit it

Attachment 140884

Yeah, you need to add a title to the field. Can call it Garage Postbit or whatever you want. It's just the name you'll use to keep track of it in the ACP

gibgib 09-02-2012 10:05 AM

Quote:

Originally Posted by KTP (Post 2356093)
tried to install this on 4.2.0

it wont let me install the language xml
and upon importing the garage xml i get this error
Code:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT COUNT(vehicle_id) AS vehicles FROM _vb4garage_user_vehicle WHERE active = '0';

MySQL Error  : Table 'xxx_vb4._vb4garage_user_vehicle' doesn't exist
Error Number  : 1146
Request Date  : Friday, August 10th 2012 @ 06:27:26 PM
Error Date    : Friday, August 10th 2012 @ 06:27:26 PM
Script        : http://www.xxx
Referrer      : http://www.xxx
IP Address    : xx.xxx.xx.xxx
Username      : xxx
Classname    : vB_Database
MySQL Version : 5.5.23-55

it looks like its adding a "." at the end of my database prefix "vb4." when it should just be "vb4"
not sure how to fix this or if this info is of any help to you?

I am also getting this.
I'm doing a fresh install on vB 4.2 & have tried the quoted remedy of changing all TYPE=MyISAM to ENGINE=MyISAM in the xml but no good.

These are the only tables in the database under garage:

Code:

garage_blocks        524 Bytes        13.0 KB        0        Yes
garage_colors        352 Bytes        13.0 KB        0        Yes
garage_currency        100 Bytes        13.0 KB        0        Yes
garage_engine_type        252 Bytes        3.0 KB        0        Yes
garage_generation        0        1.0 KB        0        Yes
garage_guestbooks        0        1.0 KB        0        Yes
garage_trims        0        1.0 KB        0        Yes
garage_vehicle_classes        792 Bytes        13.0 KB        0        Yes


Dylanblitz 09-04-2012 03:24 AM

Quote:

Originally Posted by gibgib (Post 2361916)
I am also getting this.
I'm doing a fresh install on vB 4.2 & have tried the quoted remedy of changing all TYPE=MyISAM to ENGINE=MyISAM in the xml but no good.

These are the only tables in the database under garage:

Code:

garage_blocks    524 Bytes    13.0 KB    0    Yes
garage_colors    352 Bytes    13.0 KB    0    Yes
garage_currency    100 Bytes    13.0 KB    0    Yes
garage_engine_type    252 Bytes    3.0 KB    0    Yes
garage_generation    0    1.0 KB    0    Yes
garage_guestbooks    0    1.0 KB    0    Yes
garage_trims    0    1.0 KB    0    Yes
garage_vehicle_classes    792 Bytes    13.0 KB    0    Yes


I'm sorry about that. I'm not sure why it's not creating the tables. If you want to give me temp admin access I'll try and find out why it's not installing all the tables.

gibgib 09-05-2012 11:08 AM

Hi Dylanblitz,
That is very kind of you to offer that.
Enabling the product at the moment will cause the forum to not function so I would need to be working with you at the same time. I also back up just before doing ANYTHING to the database as I have been known to stuff tables.

If it's easier can someone format this below into a query I can run in mysql admin so I can see if the table is added manually?
Code:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "garage_images (
attach_id mediumint(8) unsigned NOT NULL auto_increment,
vehicle_id mediumint(8) unsigned NOT NULL default '0',
sub_id int(11) unsigned default NULL,
attach_type varchar(10) binary default NULL,
attach_location varchar(255) binary NOT NULL default '',
attach_hits mediumint(8) unsigned NOT NULL default '0',
attach_ext varchar(100) binary NOT NULL default '',
attach_file varchar(255) binary NOT NULL default '',
attach_thumb_location varchar(255) binary NOT NULL default '',
attach_is_image tinyint(1) unsigned NOT NULL default '0',
attach_date int(11) unsigned NOT NULL default '0',
attach_filesize int(20) unsigned NOT NULL default '0',
PRIMARY KEY  (attach_id)
) ENGINE=MyISAM  AUTO_INCREMENT=1");


craigvm 09-05-2012 08:46 PM

after installing this my site is just a blank page so had to disable

Dylanblitz 09-08-2012 06:00 PM

Quote:

Originally Posted by gibgib (Post 2362849)
Hi Dylanblitz,
That is very kind of you to offer that.
Enabling the product at the moment will cause the forum to not function so I would need to be working with you at the same time. I also back up just before doing ANYTHING to the database as I have been known to stuff tables.

If it's easier can someone format this below into a query I can run in mysql admin so I can see if the table is added manually?
Code:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "garage_images (
attach_id mediumint(8) unsigned NOT NULL auto_increment,
vehicle_id mediumint(8) unsigned NOT NULL default '0',
sub_id int(11) unsigned default NULL,
attach_type varchar(10) binary default NULL,
attach_location varchar(255) binary NOT NULL default '',
attach_hits mediumint(8) unsigned NOT NULL default '0',
attach_ext varchar(100) binary NOT NULL default '',
attach_file varchar(255) binary NOT NULL default '',
attach_thumb_location varchar(255) binary NOT NULL default '',
attach_is_image tinyint(1) unsigned NOT NULL default '0',
attach_date int(11) unsigned NOT NULL default '0',
attach_filesize int(20) unsigned NOT NULL default '0',
PRIMARY KEY  (attach_id)
) ENGINE=MyISAM  AUTO_INCREMENT=1");


The problem is you're missing quite a few tables, it's more then just the one table not being created.

Noerenberg 09-15-2012 04:54 PM

Hi, first, i love this mod, but i want to change some information.
Example, {vb:raw head_title_text} how i can change the information in this raw?
I dont want to show the year and some other stuff, where i can change the text? or how i can show just the owner or the nickname?

Dylanblitz 09-20-2012 04:01 AM

Quote:

Originally Posted by Noerenberg (Post 2365689)
Hi, first, i love this mod, but i want to change some information.
Example, {vb:raw head_title_text} how i can change the information in this raw?
I dont want to show the year and some other stuff, where i can change the text? or how i can show just the owner or the nickname?

You still need this? I know you got some of the other stuff figured out, not sure if you figured this one as well.

gibgib 09-20-2012 09:21 AM

Quote:

Originally Posted by Dylanblitz (Post 2362438)
I'm sorry about that. I'm not sure why it's not creating the tables. If you want to give me temp admin access I'll try and find out why it's not installing all the tables.


Hi Dylanblitz, did you still want to have a look at this?
Is it just vbulletin admin access you needed with execute sql queries?

Dylanblitz 09-20-2012 05:19 PM

Quote:

Originally Posted by gibgib (Post 2366940)
Hi Dylanblitz, did you still want to have a look at this?
Is it just vbulletin admin access you needed with execute sql queries?

Just temp admin is good, I'd rather not have the sql execute :)

I was going to turn off the error suppression on the installer and see what's causing the problem.

Dylanblitz 09-23-2012 10:18 PM

Quote:

Originally Posted by gibgib (Post 2366940)
Hi Dylanblitz, did you still want to have a look at this?
Is it just vbulletin admin access you needed with execute sql queries?

I'm not sure what the problem was unfortunately heh. I turned off the error bypass, deleted the tables you already had and imported and it installed fine.

I also added a fix I just created and added to the top here. It's a product that will add the navigation manager entries and their permissions so you don't have to use the dynamic link.

One problem you're going to have though, your custom style doesn't have an area for submenu items.

gibgib 09-24-2012 05:31 AM

Wow it works!

Thanks heaps for that!

I give it a good go tonight but it looks like a very useful addition to our forum.

craigvm 09-25-2012 08:15 PM

hi it keeps coming up that the user has no permission for 1 of my usergroups but all the permissions are the same

Dylanblitz 09-26-2012 02:29 AM

Quote:

Originally Posted by craigvm (Post 2368521)
hi it keeps coming up that the user has no permission for 1 of my usergroups but all the permissions are the same

Are you using the basic or advanced usergroup permissions? If you want you can pm me a temp admin account, let me know what usergroup is having problems and I'll check it out.

MegaManSec 09-26-2012 12:05 PM

Mod is SQL Injectable.
Everybody please disable until OP fixes it.

Subieforums 09-28-2012 04:30 PM

Disregard, not mod related, issue resolved!
Cheers

Dylanblitz 09-29-2012 06:48 PM

Just uploaded 3.0.9 which fixes the sql injection issue as well as some other known bugs and adds the 4.2 navigation manager links. MegaManSec, thanks for bringing the sql injection issue to me.

cdoyle 09-30-2012 12:59 AM

1 Attachment(s)
Hi Dylanblitz,
Thanks for the update.

I'm running into 1 small problem though, not sure what I did wrong. When I go into my garage, I have some text under my navigation.

The new garage button has the same funky text too.
I uploaded all the images and files and when I uploaded the plugin I had rewrite set to yes.

Any ideas?

rcull 09-30-2012 02:13 PM

I find I need to upgrade my VB Pro Garage from version 2.1.7

Will this version do it?

Thanks,

Dylanblitz 09-30-2012 05:14 PM

Quote:

Originally Posted by cdoyle (Post 2369669)
Hi Dylanblitz,
Thanks for the update.

I'm running into 1 small problem though, not sure what I did wrong. When I go into my garage, I have some text under my navigation.

The new garage button has the same funky text too.
I uploaded all the images and files and when I uploaded the plugin I had rewrite set to yes.

Any ideas?

Did you upload the language file as well?

Dylanblitz 09-30-2012 05:15 PM

Quote:

Originally Posted by rcull (Post 2369754)
I find I need to upgrade my VB Pro Garage from version 2.1.7

Will this version do it?

Thanks,

Yes, all the releases include the previous release changes. So you can upgrade from the 2.1.7 to this one.

craigvm 10-06-2012 04:52 PM

some usergroups get a message saying they dont have permission when trying to add there car but all the permissions in the admincp are set the same as a usergroup that can use it any idea`s what the problem is

cTak 10-07-2012 02:10 PM

Thanks for the mod.

I just upgraded to the latest ver, running on 4.1.8, in my nav, the 2nd tab is to the garage, well the link now goes to / rather than /garage.php or garage.html

I can type it in manually and the garage is there, but the link in the nav is not working. Any idea?

Dylanblitz 10-07-2012 05:44 PM

Quote:

Originally Posted by craigvm (Post 2371218)
some usergroups get a message saying they dont have permission when trying to add there car but all the permissions in the admincp are set the same as a usergroup that can use it any idea`s what the problem is

Are you using advanced or basic permissions? If you are setting the usergroup permissions in the advanced section, make sure you have it selected in the garage general settings.

Dylanblitz 10-07-2012 05:47 PM

Quote:

Originally Posted by cTak (Post 2371378)
Thanks for the mod.

I just upgraded to the latest ver, running on 4.1.8, in my nav, the 2nd tab is to the garage, well the link now goes to / rather than /garage.php or garage.html

I can type it in manually and the garage is there, but the link in the nav is not working. Any idea?

Can you pm me temp admin access and I'll take a look?

bosken 10-09-2012 03:31 PM

Question! I want to place a Google AD in the main Garage window. Tried to paste the google code in Garage ACP but does not show. I hade before an Affiliate AD in the same place and that one worked fine (same size). Any idea?

Picture with google ad is Photoshopped.

https://vborg.vbsupport.ru/external/2012/10/52.png

https://vborg.vbsupport.ru/external/2012/10/47.jpg

Dylanblitz 10-11-2012 04:42 PM

Quote:

Originally Posted by bosken (Post 2371812)
Question! I want to place a Google AD in the main Garage window. Tried to paste the google code in Garage ACP but does not show. I hade before an Affiliate AD in the same place and that one worked fine (same size). Any idea?

Picture with google ad is Photoshopped.

What is it doing? Is there an error or bad text or just a blank space?

bosken 10-11-2012 04:57 PM

Oh sorry, just blank space. Nothing there.

Dylanblitz 10-12-2012 05:19 PM

1 Attachment(s)
Quote:

Originally Posted by bosken (Post 2372336)
Oh sorry, just blank space. Nothing there.

Hmm, I put your code in my dev system and it seems to work for me?

Attachment 141670

Maybe it's the html part, try opening the includes/garage_func_var.php and find

PHP Code:

    if ($vbulletin->options[garage_desc_html] == "1")
    {
    
$welcomemsg $bbcode_parser->do_parse(unhtmlspecialchars($vbulletin->options[garagewelcome]), $do_html true$do_smilies true$do_bbcode true$do_imgcode true$do_nl2br true$cachable false);
    } else {
    
$welcomemsg $bbcode_parser->do_parse(unhtmlspecialchars($vbulletin->options[garagewelcome]), $do_html false$do_smilies true$do_bbcode true$do_imgcode true$do_nl2br true$cachable false);
    } 

and replace it with

PHP Code:

//    if ($vbulletin->options[garage_desc_html] == "1")
//    {
    
$welcomemsg $bbcode_parser->do_parse(unhtmlspecialchars($vbulletin->options[garagewelcome]), $do_html true$do_smilies true$do_bbcode true$do_imgcode true$do_nl2br true$cachable false);
//    } else {
//    $welcomemsg = $bbcode_parser->do_parse(unhtmlspecialchars($vbulletin->options[garagewelcome]), $do_html = false, $do_smilies = true, $do_bbcode = true, $do_imgcode = true, $do_nl2br = true, $cachable = false);
//    } 

Let me know if that helps

trifive 10-13-2012 07:24 AM

Quote:

I'm running into 1 small problem though, not sure what I did wrong. When I go into my garage, I have some text under my navigation.

The new garage button has the same funky text too.
I uploaded all the images and files and when I uploaded the plugin I had rewrite set to yes.

Any ideas?
Attached Thumbnails
I just did a new install on the latest vb 4 version and I get the same problems with the navagation text as the guy list above, I installed the latest language file etc.

Did you find solution for this problem

Thanks

otis

Dylanblitz 10-14-2012 02:59 AM

Quote:

Originally Posted by trifive (Post 2372661)
I just did a new install on the latest vb 4 version and I get the same problems with the navagation text as the guy list above, I installed the latest language file etc.

Did you find solution for this problem

Thanks

otis

If you want to give me temp admin I'll take a look, or post a screen shot of what you are seeing. "Funky text" is hard to troubleshoot without seeing it :)


All times are GMT. The time now is 03:42 AM.

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.05304 seconds
  • Memory Usage 1,888KB
  • 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
  • (5)bbcode_code_printable
  • (2)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)pagenav_pagelinkrel
  • (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