SQL errors during initial installation

sbtiti · August 22nd, 2004, 12:42 AM

What appears to be the problem when we get these errors (probably a config error):

Step 2: MySQL error reported: [CREATE TABLE 4wheelfun_com_-_admlog (id int(10) NOT NULL auto_increment,adminuser varchar(50) NOT NULL default '',description varchar(255) NOT NULL default '',datestamp int(20) NOT NULL default '0',ip varchar(35) NOT NULL default '',PRIMARY KEY (id)) TYPE=MyISAM ]
Result: You have an error in your SQL syntax near '-_admlog (id int(10) NOT NULL auto_increment,adminuser varchar(50) NOT NULL defa' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [CREATE TABLE 4wheelfun_com_-_favorites (id smallint(4) NOT NULL auto_increment, userid int(8) NOT NULL default '0', product int(11) NOT NULL default '0', PRIMARY KEY (id), KEY parent (product)) TYPE=MyISAM ]
Result: You have an error in your SQL syntax near '-_favorites (id smallint(4) NOT NULL auto_increment, userid int(8) NOT NULL defa' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [CREATE TABLE 4wheelfun_com_-_laston (cat smallint(4) NOT NULL default '0', userid mediumint(9) NOT NULL default '0', laston int(11) unsigned default NULL, PRIMARY KEY (cat,userid)) TYPE=MyISAM ]
Result: You have an error in your SQL syntax near '-_laston (cat smallint(4) NOT NULL default '0', userid mediumint(9) NOT NULL def' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [CREATE TABLE 4wheelfun_com_-_categories (id smallint(4) NOT NULL auto_increment,catname varchar(255) NOT NULL default '',description varchar(255) default NULL,catorder tinyint(4) NOT NULL default '0',thumbs varchar(4) NOT NULL default 'yes',parent int(5) NOT NULL default '0',header varchar(200) default NULL,footer varchar(200) default NULL,headtags varchar(200) default NULL,ugnoview VARCHAR(255) NULL,ugnoupload VARCHAR(255) NULL,ugnopost VARCHAR(255),ugnoanno VARCHAR(255) NULL,template INT(5) NOT NULL default '0',extra1 VARCHAR(64) NULL,extra2 VARCHAR(64) NULL,extra3 VARCHAR(64) NULL,extra4 VARCHAR(64) NULL,extra5 VARCHAR(64) NULL,extra6 VARCHAR(64) NULL,children TEXT default NULL,lastproduct INT(11) UNSIGNED,products INT(11) UNSIGNED default '0',posts INT(11) UNSIGNED default '0', PRIMARY KEY (id),KEY parent(parent)) TYPE=MyISAM ]
Result: You have an error in your SQL syntax near '-_categories (id smallint(4) NOT NULL auto_increment,catname varchar(255) NOT NU' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2',0,0,0) ]
Result: You have an error in your SQL syntax near '-_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,N' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_categories VALUES (2,'A Category','Products of a particular type',1,'yes',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0) ]
Result: You have an error in your SQL syntax near '-_categories VALUES (2,'A Category','Products of a particular type',1,'yes',1,NU' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [CREATE TABLE 4wheelfun_com_-_comments (id int(11) NOT NULL auto_increment, username varchar(255) NOT NULL default '', userid mediumint(9) NOT NULL default '0', date int(15) NOT NULL default '0', comment text NOT NULL, product int(11) NOT NULL default '0', cat int(11) NOT NULL default '0', approved int(2) NOT NULL default '0', ipaddress VARCHAR(32) default '', PRIMARY KEY (id), KEY product (product), KEY cat (cat) ) TYPE=MyISAM ]
Result: You have an error in your SQL syntax near '-_comments (id int(11) NOT NULL auto_increment, username varchar(255) NOT NULL d' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [CREATE TABLE 4wheelfun_com_-_products (id int(10) NOT NULL auto_increment,user varchar(50) NOT NULL default '',userid int(8) NOT NULL default '0',cat int(11) NOT NULL default '0',date int(15) NOT NULL default '0',title varchar(255) NULL default '',description text NULL,keywords varchar(150) default NULL,bigimage varchar(100) NOT NULL default '',bigimage2 varchar(100) NOT NULL default '',bigimage3 varchar(100) NOT NULL default '',views int(10) NOT NULL default '0',approved tinyint(2) NOT NULL default '0',price float(12,2) NOT NULL default '0.00',rating varchar(24) NOT NULL default '0',watermarked varchar(5) NOT NULL default 'no',extra1 VARCHAR(255), extra2 VARCHAR(255), extra3 VARCHAR(255), extra4 VARCHAR(255), extra5 VARCHAR(255), extra6 VARCHAR(255), disporder INT(5) DEFAULT '99999' NOT NULL,enddate int(15) NOT NULL default '0',status int(15) NOT NULL default '0', ipaddress VARCHAR(32) default '', PRIMARY KEY (id),KEY userid(userid),KEY cat(cat),KEY bigimage(bigimage,cat)) TYPE=MyISAM ]
Result: You have an error in your SQL syntax near '-_products (id int(10) NOT NULL auto_increment,user varchar(50) NOT NULL default' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [CREATE TABLE 4wheelfun_com_-_settings (id int(11) NOT NULL auto_increment,title varchar(255) NOT NULL default '',varname varchar(25) NOT NULL default '',description varchar(150) NOT NULL default '',setting varchar(250) NOT NULL default '',optionorder int(3) NOT NULL default '0',section int(3) NOT NULL default '0', PRIMARY KEY (id)) TYPE=MyISAM ]
Result: You have an error in your SQL syntax near '-_settings (id int(11) NOT NULL auto_increment,title varchar(255) NOT NULL defau' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (1,'Title for your PhotoPost Classifieds Application','galleryname','','PhotoPost Classifieds',1,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (1,'Title for your PhotoPost Classifieds Application','gallery' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (2,'Web site name','webname','','My Website',2,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (2,'Web site name','webname','','My Website',2,1) ' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (3,'Your Website URL (include http://)','domain','','http://www.domain.com',3,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (3,'Your Website URL (include http://)','domain','','http://ww' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (4,'Administrator Email Address','adminemail','','admin@domain.com',4,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (4,'Administrator Email Address','adminemail','','admin@domain' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (5,'Data directory virtual path','datadir','This is the web / virtual path to the data directory.','http://www.domain.com/ppclassifieds/data',25,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (5,'Data directory virtual path','datadir','This is the web / ' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (6,'Full path to PhotoPost data directory','datafull','Full path to the image files directory.','/path/to/your/photopost/data',6,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (6,'Full path to PhotoPost data directory','datafull','Full pa' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (7,'URL to your forums main directory (optional)','vbulletin','This is the virtual path to your forum installation.','http://www.domain.com/forum',7,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (7,'URL to your forums main directory (optional)','vbulletin',' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (8,'Full path to Header include file','header','To include an HTML file as the header, enter the full path.','/path/to/php/header.htm',8,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (8,'Full path to Header include file','header','To include an ' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (9,'Full path to the Footer include file','footer','To include an HTML file as the footer, enter the full path.','/path/to/php/footer.htm',9,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (9,'Full path to the Footer include file','footer','To include' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (10,'Full path to HTML file containing head tags','headtags','','/path/to/php/headtags.htm',10,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (10,'Full path to HTML file containing head tags','headtags','' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (11,'URL to PhotoPost Classifieds PHP directory','maindir','','http://www.domain.com/ppclassifieds',11,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (11,'URL to PhotoPost Classifieds PHP directory','maindir','',' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (13,'Default number of comments per page','defaultposts','','15',1,5) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (13,'Default number of comments per page','defaultposts','','1' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (14,'Show Most Recent Additions on Index page?','mostrecent','','yes',4,9) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (14,'Show Most Recent Additions on Index page?','mostrecent','' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (15,'Number of columns for thumbnail pages','thumbcols','','4',1,4) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (15,'Number of columns for thumbnail pages','thumbcols','','4'' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (18,'Thumbnail image max width and height in pixels','previewwidth','','100',1,6) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (18,'Thumbnail image max width and height in pixels','previeww' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (19,'Maximium width of displayed image on showpoduct','maxwidth','','250',2,6) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (19,'Maximium width of displayed image on showpoduct','maxwidt' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (20,'Maximium height of displayed image on showpoduct','maxheight','','250',3,6) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (20,'Maximium height of displayed image on showpoduct','maxhei' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (21,'Maximium side for a supersized image? (Larger images will be resized down)','maxsupersize','','250',4,6) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (21,'Maximium side for a supersized image? (Larger images will' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (22,'Uploaded products require admin approval?','moderation','','yes',92,4) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (22,'Uploaded products require admin approval?','moderation','' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (33,'Display product stats on index page?','stats','','yes',1,3) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (33,'Display product stats on index page?','stats','','yes',1,' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (37,'cright','cright','','Powered by: PhotoPost Classifieds --replaceme--
Copyright 2004 All Enthusiast, Inc.',300,'0') ]
Result: You have an error in your SQL syntax near '-_settings VALUES (37,'cright','cright','','Po' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (38,'Use email to notify users?','useemail','Users can be notified of product approvals and deletions.','yes',1,2) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (38,'Use email to notify users?','useemail','Users can be noti' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (41,'User Registration System','vbversion','','sellerspost',12,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (41,'User Registration System','vbversion','','sellerspost',12' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (45,'Number of columns for most recent additions section?','recentcols','','4',1,9) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (45,'Number of columns for most recent additions section?','re' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (46,'Number of products to display in the most recent additions section?','recentnum','','12',2,9) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (46,'Number of products to display in the most recent addition' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (49,'URL to PhotoPost Classifieds images directory','idir','','http://www.domain.com/images',13,1) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (49,'URL to PhotoPost Classifieds images directory','idir','',' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (50,'Depth (number of levels) of categories to display.','catdepth','','1',2,3) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (50,'Depth (number of levels) of categories to display.','catd' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (51,'Allow users to be notified of new posts via email?','usenotify','','yes',2,2) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (51,'Allow users to be notified of new posts via email?','usen' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (57,'Exclude admin uploads from product approval process?','adminexclude','','yes',101,4) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (57,'Exclude admin uploads from product approval process?','ad' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (58,'Show post count and photo details for cats without thumbs?','catdetails','','no',3,3) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (58,'Show post count and photo details for cats without thumbs' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (61,'Use COPPA for registration?','coppa','','yes',3,8) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (61,'Use COPPA for registration?','coppa','','yes',3,8) ' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (62,'Full Path to Registration Rules, or leave blank for default','rules','','',4,8) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (62,'Full Path to Registration Rules, or leave blank for defau' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (63,'Require verification of email address upon registration?','emailverify','','yes',5,8) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (63,'Require verification of email address upon registration?'' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (64,'Your mailing address to receive COPPA permission forms?','address','','',6,8) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (64,'Your mailing address to receive COPPA permission forms?',' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (65,'Full path to COPPA rules file, or leave blank for default?','copparules','','',7,8) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (65,'Full path to COPPA rules file, or leave blank for default' at line 1
Database: 4wheelfun_com_-_class

Step 2: MySQL error reported: [INSERT INTO 4wheelfun_com_-_settings VALUES (66,'Allow new user registrations?','allowregs','','yes',8,8) ]
Result: You have an error in your SQL syntax near '-_settings VALUES (66,'Allow new user registrations?','allowregs','','yes',8,8) ' at line 1
Database: 4wheelfun_com_-_class

Chuck S · August 22nd, 2004, 07:35 AM

You have entered incorrect mysql information

I seriously doubt the database name is 4wheelfun_com_-_

Usually on any server that follows that prefix situation it would be 4wheelfun_com_-_photopost

so your leaving off the actual database name

sbtiti · August 22nd, 2004, 03:31 PM

4wheelfun_com_-_ is the prefix we were told we must use for MySQL. The database name would then be: 4wheelfun_com_-_class. At the end of each error paragragh (as you can see in the original message) it says that the Database is: 4wheelfun_com_-_class Do we need to set the database name to just "class" instead of "4wheelfun_com_-_class"? Right now the config-inc.php should have the database name as "4wheelfun_com_-_class" and a prefix of "4wheelfun_com_-_"

Chuck S · August 22nd, 2004, 03:47 PM

Your missing what I am saying

In the first part of the install it asks you for the mysql information. You have entered the database incorrectly as I stated above. I explained this and lets see if I can make it clearer

You have entered 4wheelfun_com_-_ as the classifieds database

It should be 4wheelfun_com_-_class

sbtiti · August 23rd, 2004, 10:20 PM

Please see below a copy of our config-inc.php file (less login info). I cannot see anything wrong or is the problem somewhere else in the install?

<?php
//**************** External Header Configuration ****************//
//
// the isset prevents vB headers from being sent during login/logout -
// do not remove this line as it may cause the vB headers to interfere with the login/logout process
//
// To include the file, edit the header-inc.php
//

if ( !isset($skip_exheader) ) {
include "header-inc.php";
}

// PhotoPost Classifieds Pro Version Number
$VERSION = "1.8";

// Path to your PhotoPost installation - no end slashes
$PP_PATH = ".";

//**************** MySQL Database Configuration ****************//

// PhotoPost Classifieds database host address, or leave as localhost
$host="localhost";

// PhotoPost Classifieds's database name
$database="4wheelfun_com_-_class";

// MySQL username and password to access PhotoPost Classifieds's database
//
// These two variables are for the userid and password needed to access
// the PhotoPost Classifieds database named above.
$mysql_user="xxxxxxxxxx";
$mysql_password="xxxxxxxxxx";

// User database host address, or leave as localhost
$host_bb="localhost";

// If you want to use a prefix for your database, enter it here.
// NOTE: This variable can only be set PRIOR to your first installation of PhotoPost Classifieds;
// existing databases will not be changed and you will be unable to connect if you change
// this variable after performing a default installation.
$pp_db_prefix = "4wheelfun_com_-_";

// User database MySQL database name
//
// This is the variable for the User Database; if you are using Internal
// as your registration system, then these variables are the same as the
// ones above. If you are linking to a message board system,
// thse variables should be set to the database, user and password for that
// database.
$database_bb="4wheelfun_com_-_class";

// MySQL username and password to access user database
//
// These two variables are for the userid and password needed to access
// the PhotoPost Classifieds or BB database.
$user_bb="xxxxxxxxxx";
$password_bb="xxxxxxxxxx";

//
// VB3 License Number required for VB3 integration
//
$vblicense = '***YOUR VB LICENCE NUMBER ***';

//**************** Application Configuration ****************//

// Are the Boards OPEN or CLOSED?
// set this to "closed" if you want your boards to be offline
$ppboards="open";

// Display message when closed
$closedmsg = "The 4Wheelfun.com Classifieds are temporarily down for maintainence.";

// Language
// This needs to be set to the name of the directory used inside of the languages directory
$pplang = "english";

//////////////////////// Application Configuration ////////////////////////////////
// These variables set the path to the MOGRIFY commands on your system
//
// This only needs to be set if you are allowing ZIP uploads. These are full paths,
// including the name of the executable (.exe extensions for windows)
// The -j option for Info-ZIP's UNZIP tells it to ignore paths in ZIP file
//
// This option is only used in the event the internal UNZIP does not work for you
//$zip_command = "/usr/bin/unzip -j";

// Path to MOGRIFY executable
// There should be no spaces in the directory names, use short names if necessary.
// Examples:
// $mogrify_command = "c:\progra~1\imagemagick\mogrify.exe";
// $mogrify_command = "c:\ImageMagick\mogrify.exe";
$mogrify_command = "/usr/bin/X11/mogrify";

// Some systems have a problem with users who upload PhotoShop 7 images which can cause a browser
// load problem. If you would like to "clean" any JPG image uploaded before being processed;
// enter the path to your jpegtran executable.
// The path should include the full path (including executable).
// Example: $jpegtran = "/usr/bin/jpegtran";
// Exmaple: $jpegtran = "c:/windows/system/jpegtran.exe";
$jpegtran = "/usr/bin/jpegtran";

// If you want to perform online backups, you need to set the paths below
// mysqldumppath is the path, including filename for the executable
// backupdir is the path to the DIRECTORY where you want the backups stored
$mysqldumppath = "/usr/bin/mysqldump";
$backupdir = "";

// ImageMagick/GD2 support
// You have the option of using Imagemagick or GD image support (or none at all)
// -1 = no image support (images will not be accepted)
// 0 = use ImageMagick/mogrify
// 1 = use GD2
// 2 = use GD1
$usegd = 0;

// on-the-fly watermarks
// requires GD2 and you must edit the file watermark.php
$onthefly=0;

// Debug variable.
// 0 = No debug notifications
// 1 = Program should generate an email and send it to the site administrator
// 2 = Program should terminate with a formatted screen with error message
// When set to 0 or 1, the program will not end on non-fatal errors.
$debug=2;

// Cookie variables
// This should be set to match the path/domain for your cookies,
// / = "/"; sets the cookie to be usable throughout the site.
// .4wheelfun.com = ".domain.com"; sets the cookie to be usable across the domain
// If your BB system has a different setting, then you need to put that path here as well.
$cookie_path = "/";
$cookie_domain = ".4wheelfun.com";

// Cookie Prefix
// Right now this only applies to UBBThreads, phpBB2 or Nuke; if you have your cookies set to a custom
// prefix, set it here.
$cookieprefix="";

// ZLIB compression
// Set to "1" if you want to enable Zlib compression
$compression="0";

// Date Format
// you can change the format of how dates are displayed
// keywords:
// dow = day of week (Mon, Tue, Wed...)
// month = month (Jan, Feb, Mar...)
// mm = month in numerical format, dd = date, yyyy = year
$ppdateformat = "dow, month, dd, yyyy";

// If you are running VB and want the server to display the time as an offset
// of GMT (for example, to the timezone where your server is located), enter the
// offset here
$gmtoffset = -7;

// IP caching
// This variable is used to track IP addresses and userids for voting and viewing purposes
// $ipcache is set in HOURS. To limit voting and view increments to once a day, you would set
// $ipcache to 24. Depending on the volume of activity on your set, you may want to monitor
// the size of your cache and adjust accordingly.
//
// Setting $ipcache to 0 disables this feature.
$ipcache = 0;

?>

Chuck S · August 24th, 2004, 08:57 PM

Do not set your table prefix to this

$pp_db_prefix = "4wheelfun_com_-_";

try something like this

$pp_db_prefix = "class_";

sbtiti · August 24th, 2004, 10:16 PM

So your db_prefix doesn't need to be the same as the one we were given by MySQL when it was setup on the server?

dkiefer · August 25th, 2004, 08:10 AM

Login to phpMyAdmin or whatever script you use to view your database. If you do not have access to your database ask your host to provide the exact name of your database. With my host they add dkiefer_ to the beginning of my databases so I have a database named dkiefer_photopost which in config-inc.php looks like:
// PhotoPost's database name
$database="dkiefer_photopost";

I then prefer to add a prefix to the tables for each of the PhotoPost products I install so for PP Pro I add the prefix pp_ and in the config-inc.php file it looks like:
// this variable after performing a default installation.
$pp_db_prefix = "pp_";

This makes my tables inside of dkiefer_photopost look like pp_settings or pp_photos and so on.

If you look at phpMyAdmin you should be able to see what your exact database name is and the prefix for Classifieds. If you cannot figure it out I would suggest purchasing the install service we provide so one of our installers can help you find the problem.

sbtiti · August 25th, 2004, 10:06 AM

Thanks for the more explicit directions. I got the problem fixed last night. Although I ended up wiping my entire web site and starting over I think the problem was MySQL gave us the prefix as yours did (it was long) and I confused it with the PP prefix and thought they had to be the same and it wouldn't work with either the long one or the same, not sure which. When I recreated the site I changed the default sql prefix to a short one and then used pp_ for my classifieds prefix and all went well.

One note to change in the install instructions besides explaining this prefix thing, is they are wrong on the CHMOD for config_inc.php...I had to make it 666 before I could save the new config - NOT 664 AS THE INSTRUCTIONS STATED!

THANKS FOR ALL THE HELP.

Chuck S · August 25th, 2004, 10:22 AM

This is right on the install instructions

Step 1 will let your review and/or set your options in config-inc.php. Your config-inc.php MUST be writable by install for this step to succeed. If you get an error, it is because the server does not have write access to the file. Change permissions to 777 and run again.

sbtiti · August 25th, 2004, 07:57 PM

Chuck, sorry but I beg to differ with you. I went to the instructions I was pointed to in the email and the only information on CHMOD is pasted below:

Now create a directory on your web server for PhotoPost Classifieds. The directory needs to be accessible via the web. Using an FTP program, upload PhotoPost Classifieds directories and files from your local machine to your web server. The directory structure on your web server should be as follows:

pp-classifieds
images (chmod 755)
uploads (chmod 777)
help (chmod 755)
forums (chmod 755)
languages (chmod 755)
stylesheets (chmod 755)
templates (chmod 777)
1 (chmod 777)
2 (chmod 777)
777)

All permissions for .php and .sql files should be set to chmod 644. <------<<<

The line above tells you to set the file to 644 and it was already by default but I got errors until I changed it to 666 (777 would work also). I let my PC search your document for any instance of config-inc.php and there is only one - in Step 5 where it says to check the config-inc.php file if you have errors during the database setup. I didn't see any mention in the entire document to set config-inc.php to (chmod 777).

I wouldn't bring this to your attention except we had the same problem when we installed some of your other products over 4 months ago. It would be nice if someone would take the time to change the Installation Guide. It could save you a lot of future support messages. (I think there should also be a mention that the Photo Post $pp_db_prefix is not the same prefix that MySQL requests when it is setup, but maybe I'm the only one dumb enough to confuse the two.)

THANKS AGAIN FOR THE ASSISTANCE

Chuck S · August 25th, 2004, 08:12 PM

Yes you can beg to differ from me that is your right

HOWEVER your quoting right from the install directions posted on this site YES

The paragraph I quoted from is right on that page and is the basic web installation instruction and states the config file needs write permissions. Read below what you posted above in the installation instructions

Quote:

4.) Web Installation Script

Now you are ready to run the web based installation script that will check your server for PhotoPost's requirements and set up your PhotoPost database. Open install.php in your web browser and follow the prompts.

Step 1 will let your review and/or set your options in config-inc.php. Your config-inc.php MUST be writable by install for this step to succeed. If you get an error, it is because the server does not have write access to the file. Change permissions to 777 and run again.

Step 2 will test your server for the graphics selection you chose. If you selected ImageMagick, it will look for mogrify at the path you specified. If you selected GD, it will test to make sure the GD library is installed. If either returns an error, then you need to go back and either find the proper path to mogrify - or your server does not support the GD library you selected.

To proceed to the next step, click on "Click here for a FRESH install".

Step 3 will check your database settings. If the server cannot connect to the databases you specified, you will get an error. To fix this you will need to edit your config-inc.php variable settings and hit REFRESH; or restart install.php and edit your selections. Once verified, the install program will begin populating your tables with our data. Finally, the script will ask whether you want to install PhotoPost using its Internal User registration system, or to instead work with an existing/external Forum user registration system.

Step 4 will prompt you for some server configuration information, and our script tries to guess as to your server's settings. Please don't assume that the defaults are correct, double check them. If you are using PhotoPost with a forum, note that the following forum versions correspond with the selections in the drop down box (those using PhotoPost's internal registration system can ignore this):

2.2.0 = All vBulletin versions v2.2.0 and newer
2.0.3 = vBulletin versions between 2.0.3 and v2.2.0 (not including 2.2.0)
phpBB2 = phpBB 2.0+ (RC versions not supported)
UBBThreads v6 = UBB Threads versions 6.x
DCForums = DCForums 1.2
InvisionBoard = IPB 1.1.1

Step 5 will set up your user and usergroups database. If you receive an error message at this point, check your config-inc.php file and be sure that the settings for your $bb_database are correct. Make sure that your MySQL database for PhotoPost is properly set up and that the username and password that you're using to access it are correct and that the user has insert, update, delete, and alter privledges.

PhotoPost installation is now complete. Be sure you remove your install.php file (and the various upgradeXX.php/.sql)files) from your server's PhotoPost directory to prevent malicious users from altering your PhotoPost settings. Leave the .sql files in place as they are used later if you reimport usergroups.

To proceed, open the administrative control panel, adm-index.php, in your browser.