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)

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.


All times are GMT. The time now is 04:04 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.02207 seconds
  • Memory Usage 1,760KB
  • 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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