Page 16 of 51

Posted: Thu Jun 01, 2006 11:37 am
by LightningGA
I started reading through some of the pages.....

Has anyone used this with the BBTech template???

This is an amazing mod and really want to use it on our car club forum but I'm not a big fan of the SubSilver template.

Posted: Fri Jun 02, 2006 3:44 am
by madpwr1
got everythin to work for the garage ... thanks slayer1011 for all your help! :)

Posted: Fri Jun 02, 2006 3:24 pm
by tat2stuff
I'm getting this error with install:

CREATE TABLE phpbb_garage ( `id` int(10) unsigned NOT NULL auto_increment, `member_id` int(10) NOT NULL default '0', `made_year` varchar(4) NOT NULL default '2003', `color` varchar(128) default NULL, `mileage` int(10) unsigned NOT NULL default '0', `mileage_units` varchar(32) NOT NULL default 'Miles', `price` int(10) unsigned default NULL, `currency` varchar(32) NOT NULL default 'USD', `comments` varchar(255) default NULL, `image_id` int(10) unsigned default NULL, `views` int(10) unsigned NOT NULL default '0', `date_created` int(10) default NULL, `date_updated` int(10) default NULL, `make_id` int(10) unsigned NOT NULL default '0', `model_id` int(10) unsigned NOT NULL default '0', `guestbook_pm_notify` tinyint(1) NOT NULL default '0', `main_vehicle` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `date_created` (`date_created`), KEY `date_updated` (`date_updated`), KEY `member_id` (`member_id`), KEY `views` (`views`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_business ( `id` int(10) unsigned NOT NULL auto_increment, `title` varchar(255) default NULL, `address` varchar(255) default NULL, `telephone` varchar(32) default NULL, `fax` varchar(32) default NULL, `website` varchar(255) default NULL, `email` varchar(32) default NULL, `opening_hours` varchar(255) default NULL, `insurance` tinyint(1) NOT NULL default '0', `retail_shop` tinyint(1) NOT NULL default '0', `web_shop` tinyint(1) NOT NULL default '0', `garage` tinyint(1) NOT NULL default '0', `pending` tinyint(1) NOT NULL default '0', `comments` text, PRIMARY KEY (`id`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_categories ( `id` int(10) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `image_id` int(10) unsigned default NULL, PRIMARY KEY (`id`), KEY `title` (`title`(100)), KEY `id` (`id`,`title`(100)) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_config ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_gallery ( `id` int(10) unsigned NOT NULL auto_increment, `garage_id` int(10) unsigned NOT NULL default '0', `image_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_guestbooks ( `id` int(10) unsigned NOT NULL auto_increment, `garage_id` int(10) unsigned NOT NULL default '0', `author_id` mediumint(8) NOT NULL default '0', `post_date` int(10) NOT NULL default '0', `ip_address` varchar(16) NOT NULL default '', `post` text, PRIMARY KEY (`id`), KEY `garage_id` (`garage_id`), KEY `author_id` (`author_id`), KEY `post_date` (`post_date`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_images ( `attach_id` int(10) unsigned NOT NULL auto_increment, `attach_location` varchar(255) NOT NULL default '', `attach_hits` int(10) unsigned NOT NULL default '0', `attach_ext` varchar(10) NOT NULL default '', `attach_file` varchar(255) NOT NULL default '', `attach_thumb_location` varchar(128) NOT NULL default '', `attach_thumb_width` smallint(5) NOT NULL default '0', `attach_thumb_height` smallint(5) NOT NULL default '0', `attach_is_image` tinyint(1) NOT NULL default '0', `attach_date` int(10) NOT NULL default '0', `attach_filesize` int(10) NOT NULL default '0', PRIMARY KEY (`attach_id`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_insurance ( `id` int(10) NOT NULL auto_increment, `garage_id` int(10) unsigned default NULL, `business_id` int(10) unsigned default NULL, `premium` int(10) unsigned default NULL, `cover_type` varchar(255) default NULL, `comments` text, PRIMARY KEY (`id`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_makes ( `id` int(10) unsigned NOT NULL auto_increment, `make` varchar(255) NOT NULL default '', `pending` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), KEY `make` (`make`(64)) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_models ( `id` int(10) unsigned NOT NULL auto_increment, `make_id` int(10) unsigned NOT NULL default '0', `model` varchar(255) NOT NULL default '', `pending` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), KEY `make_id` (`make_id`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_mods ( `id` int(10) unsigned NOT NULL auto_increment, `garage_id` int(10) unsigned NOT NULL default '0', `member_id` int(10) NOT NULL default '0', `category_id` int(10) unsigned NOT NULL default '0', `title` varchar(255) NOT NULL default '', `price` int(10) unsigned NOT NULL default '0', `install_price` int(10) unsigned NOT NULL default '0', `product_rating` tinyint(2) default NULL, `install_rating` tinyint(2) default NULL, `business_id` int(10) default NULL, `install_business_id` int(10) default NULL, `comments` text, `install_comments` text, `image_id` int(10) unsigned default NULL, `date_created` int(10) default NULL, `date_updated` int(10) default NULL, PRIMARY KEY (`id`), KEY `member_id` (`member_id`), KEY `garage_id_2` (`garage_id`,`category_id`), KEY `category_id` (`category_id`), KEY `garage_id` (`garage_id`), KEY `date_created` (`date_created`), KEY `date_updated` (`date_updated`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_quartermile ( `id` int(10) unsigned NOT NULL auto_increment, `garage_id` int(10) unsigned NOT NULL default '0', `rt` decimal(6,3) default NULL, `sixty` decimal(6,3) default NULL, `three` decimal(6,3) default NULL, `eight` decimal(6,3) default NULL, `eightmph` decimal(6,3) default NULL, `thou` decimal(6,3) default NULL, `quart` decimal(6,3) default NULL, `quartmph` decimal(6,3) default NULL, `pending` tinyint(1) NOT NULL default '1', `image_id` int(10) unsigned default NULL, `rr_id` int(10) unsigned default NULL, `date_created` int(10) default NULL, `date_updated` int(10) default NULL, PRIMARY KEY (`id`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_rollingroad ( `id` int(10) unsigned NOT NULL auto_increment, `garage_id` int(10) unsigned NOT NULL default '0', `bhp` decimal(6,2) default NULL, `bhp_unit` varchar(32) default NULL, `torque` decimal(6,2) default NULL, `torque_unit` varchar(32) default NULL, `boost` decimal(6,2) default NULL, `boost_unit` varchar(32) default NULL, `nitrous` int(10) default NULL, `dynocenter` varchar(32) default NULL, `peakpoint` decimal(7,3) default NULL, `image_id` int(10) unsigned default NULL, `date_created` int(10) default NULL, `date_updated` int(10) default NULL, `pending` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

CREATE TABLE phpbb_garage_rating ( `id` int(10) NOT NULL auto_increment, `garage_id` int(10) NOT NULL default '0', `rating` int(10) NOT NULL default '0', `user_id` int(10) NOT NULL default '0', `rate_date` int(10) default NULL, PRIMARY KEY (`id`) )
+++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

INSERT INTO phpbb_garage_config VALUES ('max_user_cars', '1')
+++ Error: Table 'phpbb_6.phpbb_garage_config' doesn't exist

INSERT INTO phpbb_garage_config VALUES ('year_start', '1980')
+++ Error: Table 'phpbb_6.phpbb_garage_config' doesn't exist

INSERT INTO phpbb_garage_config VALUES ('year_end', '1')
+++ Error: Table 'phpbb_6.phpbb_garage_config' doesn't exist

INSERT INTO phpbb_garage_config VALUES ('allow_bbcode_car', '1')
+++ Error: Table 'phpbb_6.phpbb_garage_config' doesn't exist

Posted: Fri Jun 02, 2006 7:15 pm
by slayer1011
LightningGA wrote: I started reading through some of the pages.....

Has anyone used this with the BBTech template???

This is an amazing mod and really want to use it on our car club forum but I'm not a big fan of the SubSilver template.



you can get it working with any template, you just have to know how to edit them accordingly... eg: your overall header Menu, the default configuration is for subSilver, but with a little bit of research (reading your templates) you can make the menu look properly...

madpwr1 : your welcoem by the way...
he had a small template problem, it just didnt look right, so i checked otu his template and had that problem fixed in like 1 min ;) just had to edit the new code to match the old code.
(in some cases an image may be required to make it fit better)



tat2stuff : it appears you do not have Admin access, OR more likly your host isn't allowing the PHP file to alter the database?

which is weird, cause if you cant alter the DB phpBB wont even run.. so forget that lol... must be the +++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

not sure what is really the problem... maybe Poyntesm knows.. if you dont seea responce from him in a day, ask over here... www.phpbbgarage.com

Posted: Fri Jun 02, 2006 7:31 pm
by tat2stuff
slayer1011 wrote:
LightningGA wrote:I started reading through some of the pages.....

Has anyone used this with the BBTech template???

This is an amazing mod and really want to use it on our car club forum but I'm not a big fan of the SubSilver template.



you can get it working with any template, you just have to know how to edit them accordingly... eg: your overall header Menu, the default configuration is for subSilver, but with a little bit of research (reading your templates) you can make the menu look properly...

madpwr1 : your welcoem by the way...
he had a small template problem, it just didnt look right, so i checked otu his template and had that problem fixed in like 1 min ;) just had to edit the new code to match the old code.
(in some cases an image may be required to make it fit better)



tat2stuff : it appears you do not have Admin access, OR more likly your host isn't allowing the PHP file to alter the database?

which is weird, cause if you cant alter the DB phpBB wont even run.. so forget that lol... must be the +++ Error: Access denied for user 'yscr_bbJBkK'@'localhost' to database 'phpbb_6'

not sure what is really the problem... maybe Poyntesm knows.. if you dont seea responce from him in a day, ask over here... www.phpbbgarage.com


I have no other access issues and just installed several other mods with no problems, what is " 'yscr_bbJBkK'@'localhost' " , shouldn't that show up as my user info?

Posted: Fri Jun 02, 2006 8:14 pm
by slayer1011
tat2stuff wrote: I have no other access issues and just installed several other mods with no problems, what is " 'yscr_bbJBkK'@'localhost' " , shouldn't that show up as my user info?


That is why im consused.. i assume your info there is somethign liek mine..

yscr = DB login name, or cpanel/vdeck login (or similar)
bbJBkk = database name?

mine shows like so
idolcrea_mainDB
idolcrea= vdeck login
mainDB = database name..

its strange i have never seen that error... i will let Poyntesm know his ecpertise are needed over here...

Posted: Fri Jun 02, 2006 8:35 pm
by poyntesm
tat2stuff -> What DB is this one? MySQL, MSSQL or Postgre?

(thanks for the pm slayer..keep forgetting to check this thread as he mentioned my site is where I am most often at the moment.)

Posted: Fri Jun 02, 2006 11:06 pm
by tat2stuff
poyntesm wrote: tat2stuff -> What DB is this one? MySQL, MSSQL or Postgre?

(thanks for the pm slayer..keep forgetting to check this thread as he mentioned my site is where I am most often at the moment.)


this is all new to me, so bear with me, I think its MySQL, it's hosted on Yahoo

Posted: Sat Jun 03, 2006 12:10 am
by tat2stuff
'phpbb_6' seems to be the issue, I installed easymod and got an autherization error with 'phpbb_6'. It installed, I tried to install Garage that way, I got through step 2of 3 and it froze. I really want this mod on my forum :(

Posted: Sat Jun 03, 2006 1:12 am
by tat2stuff
tat2stuff wrote: 'phpbb_6' seems to be the issue, I installed easymod and got an autherization error with 'phpbb_6'. It installed, I tried to install Garage that way, I got through step 2of 3 and it froze. I really want this mod on my forum :(


well I used the search feature and found this http://www.phpbb.com/phpBB/viewtopic.ph ... ght=phpbb6

it appears yahoo is the problem :?

Posted: Sat Jun 03, 2006 11:46 am
by shane28546
I have installed this mod but am now getting this message. Help?

Could not query Garage config information

DEBUG MODE

SQL Error : 1146 Table 'mrocncco_p_bb2.GARAGE_CONFIG_TABLE' doesn't exist

SELECT config_name, config_value FROM GARAGE_CONFIG_TABLE

Line : 32
File : functions_garage.php

Posted: Sat Jun 03, 2006 4:55 pm
by shane28546
BTT, Anyone?

Posted: Sat Jun 03, 2006 7:45 pm
by poyntesm
shane28546 -> Check you have made all the edits...that shows missing edits for constants.php

tat2stuff -> Ok..let me know if you need anymore help.

Posted: Sun Jun 04, 2006 3:21 am
by shane28546
poyntesm wrote: shane28546 -> Check you have made all the edits...that shows missing edits for constants.php


Thanks for the help. I had someone install this mod for me because I just can't figure it out. Plus I am using startlogic as a host and got phpbb through them. So I am really completely clueless. Is this an easy fix? I asked the guy who installed it for me and he said to ask here.

Posted: Sun Jun 04, 2006 1:16 pm
by poyntesm
The install garage.txt list all the phpBB files that need to be editted and what to edit. You just need to process them one by one..it is not difficult at all.