PhotoPost Community
Page 1 of 4 1 234
Show 40 post(s) from this thread on one page

PhotoPost Community (http://www.photopost.com/forum/)
-   Classifieds Installation & Upgrades (http://www.photopost.com/forum/classifieds-installation-upgrades/)
-   -   Classifieds Installation Error - (http://www.photopost.com/forum/classifieds-installation-upgrades/139665-classifieds-installation-error.html)

EXPOSED March 27th, 2009 08:50 PM
Classifieds Installation Error -
 
Upon running through the installation, at step 3 I'm getting all kinds of database errors. Scared the mess out of me! :eek:

What the heck did I do wrong??

Quote:
Step 3: MySQL error reported: [CREATE TABLE 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)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: Table 'admlog' already exists
Database: ******

Step 3: MySQL error reported: [CREATE TABLE 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)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: Table 'favorites' already exists
Database: ******

Step 3: MySQL error reported: [CREATE TABLE 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)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: Table 'laston' already exists
Database: ******

Step 3: MySQL error reported: [CREATE TABLE 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', adcost float(12,2) default '0' NOT NULL, adhigh float(12,2) default '0' NOT NULL, adbold float(12,2) default '0' NOT NULL, adital float(12,2) default '0' NOT NULL, allowbid varchar(3) default 'no' NOT NULL,moderators TEXT default NULL, thumbnail VARCHAR(125) NOT NULL default '0',intro VARCHAR(3) default 'no' NOT NULL, introtitle VARCHAR(128) DEFAULT NULL, introcopy TEXT DEFAULT NULL, theme VARCHAR(32) NOT NULL, sortorder INT(2) NOT NULL DEFAULT '1', frames VARCHAR(32) DEFAULT NULL, numextra INT(3) NOT NULL default '0', PRIMARY KEY (id),KEY parent(parent)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: Table 'categories' already exists
Database: ******

Step 3: MySQL error reported: [INSERT INTO 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,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','0','', 0);]
Result: Duplicate entry '1' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO 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,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','0','', 0);]
Result: Duplicate entry '2' for key 'PRIMARY'
Database:******

Step 3: MySQL error reported: [CREATE TABLE 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) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: Table 'comments' already exists
Database: ******

Step 3: MySQL error reported: [CREATE TABLE 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 '',bigimage4 varchar(100) NOT NULL default '',bigimage5 varchar(100) NOT NULL default '',bigimage6 varchar(100) NOT NULL default '',bigimage7 varchar(100) NOT NULL default '',bigimage8 varchar(100) NOT NULL default '',bigimage9 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',shipping 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 '', zipcode VARCHAR(5) NULL, adoptions INT(6) default '0' NOT NULL, isauction INT(2) default '0' NOT NULL, highbidder INT(12) default '0' NOT NULL, maxbid float(16,2) default '0.00' NOT NULL, numbids INT(6) default '0' NOT NULL, paid INT(1) default '0' NOT NULL, duration INT(3) DEFAULT '30' NOT NULL, currency VARCHAR(255) DEFAULT 'USD' NOT NULL, buyit VARCHAR(3) NOT NULL default 'no', reserve float(12,2) NOT NULL default '0.00', quantity INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (id),KEY userid(userid),KEY cat(cat),KEY bigimage(bigimage,cat)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: Table 'products' already exists
Database: ******

Step 3: MySQL error reported: [CREATE TABLE settings (id int(11) NOT NULL auto_increment,title varchar(255) NOT NULL default '',varname varchar(25) 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)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: Table 'settings' already exists
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (1, 'setting1', 'galleryname', 'PhotoPost Classifieds', 1, 1);]
Result: Duplicate entry '1' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (2, 'setting2', 'webname', 'domain.com', 2, 1);]
Result: Duplicate entry '2' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (10, 'setting10', 'headtags', '/path/to/classifieds/headtags.htm', 10, 1);]
Result: Duplicate entry '10' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (11, 'setting11', 'maindir', 'http://www.domain.com/classifieds', 11, 1);]
Result: Duplicate entry '11' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (13, 'setting13', 'defaultposts', '15', 1, 5);]
Result: Duplicate entry '13' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (14, 'setting14', 'mostrecent', 'yes', 4, 9);]
Result: Duplicate entry '14' for key 'PRIMARY'
Database: *******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (15, 'setting15', 'thumbcols', '4', 1, 4);]
Result: Duplicate entry '15' for key 'PRIMARY'
Database: ********

Step 3: MySQL error reported: [INSERT INTO settings VALUES (18, 'setting18', 'previewwidth', '100', 1, 6);]
Result: Duplicate entry '18' for key 'PRIMARY'
Database: ********

Step 3: MySQL error reported: [INSERT INTO settings VALUES (19, 'setting19', 'maxwidth', '400', 2, 6);]
Result: Duplicate entry '19' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (20, 'setting20', 'maxheight', '400', 3, 6);]
Result: Duplicate entry '20' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (21, 'setting21', 'maxsupersize', '1024', 4, 6);]
Result: Duplicate entry '21' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (33, 'setting33', 'stats', 'yes', 1, 3);]
Result: Duplicate entry '33' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (37, 'setting37', 'cright', 'Powered by: PhotoPost Classifieds 3.1 --replaceme--
Copyright 2009 All Enthusiast, Inc.', 300, 0);]
Result: Duplicate entry '37' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (38, 'setting38', 'useemail', 'yes', 1, 2);]
Result: Duplicate entry '38' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (41, 'setting41', 'vbversion', 'sellerspost', 14, 2);]
Result: Duplicate entry '41' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (45, 'setting45', 'recentcols', '4', 1, 9);]
Result: Duplicate entry '45' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (46, 'setting46', 'recentnum', '12', 2, 9);]
Result: Duplicate entry '46' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (49, 'setting49', 'idir', 'http://www.domain.com/classifieds/images', 13, 1);]
Result: Duplicate entry '49' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (50, 'setting50', 'catdepth', '1', 2, 3);]
Result: Duplicate entry '50' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (51, 'setting51', 'usenotify', 'yes', 2, 2);]
Result: Duplicate entry '51' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (57, 'setting57', 'adminexclude', 'yes', 101, 4);]
Result: Duplicate entry '57' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (58, 'setting58', 'catdetails', 'no', 3, 3);]
Result: Duplicate entry '58' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (61, 'setting61', 'coppa', 'yes', 3, 8);]
Result: Duplicate entry '61' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (62, 'setting62', 'rules', '', 4, 8);]
Result: Duplicate entry '62' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (63, 'setting63', 'emailverify', 'yes', 5, 8);]
Result: Duplicate entry '63' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (64, 'setting64', 'address', '', 6, 8);]
Result: Duplicate entry '64' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (65, 'setting65', 'copparules', '', 7, 8);]
Result: Duplicate entry '65' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (66, 'setting66', 'allowregs', 'yes', 8, 8);]
Result: Duplicate entry '66' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (67, 'setting67', 'allowup', 'yes', 3, 2);]
Result: Duplicate entry '67' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (68, 'setting68', 'allowpost', 'yes', 4, 2);]
Result: Duplicate entry '68' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (69, 'setting69', 'recentdefault', 'yes', 3, 9);]
Result: Duplicate entry '69' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (70, 'setting70', 'cjurl', '', 6, 2);]
Result: Duplicate entry '70' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (71, 'setting71', 'uploadnotify', 'yes', 10, 2);]
Result: Duplicate entry '71' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (75, 'setting75', 'tablewidth', '100%', 5, 9);]
Result: Duplicate entry '75' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (76, 'setting76', 'emailunique', 'yes', 1, 8);]
Result: Duplicate entry '76' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (78, 'setting78', 'disrandom', 'no', 4, 3);]
Result: Duplicate entry '78' for key 'PRIMARY'
Database:******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (79, 'setting79', 'dispopular', 'no', 5, 3);]
Result: Duplicate entry '79' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (81, 'setting81', 'zipuploaddir', '', 16, 1);]
Result: Duplicate entry '81' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (82, 'setting82', 'zipuploadurl', 'http://www.domain.com/classifieds/uploads', 17, 1);]
Result: Duplicate entry '82' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (83, 'setting83', 'dprefix', '', 3, 14);]
Result: Duplicate entry '83' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (84, 'PhotoPost Classifieds Version', 'pversion', '3.1', 53, 0);]
Result: Duplicate entry '84' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (86, 'setting86', 'annotate', 'no', 1, 10);]
Result: Duplicate entry '86' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (87, 'setting87', 'gravity', 'SouthEast', 2, 10);]
Result: Duplicate entry '87' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (88, 'setting88', 'imgquality', '70', 7, 6);]
Result: Duplicate entry '88' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (89, 'setting89', 'resizeorig', 'yes', 8, 6);]
Result: Duplicate entry '89' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (90, 'setting90', 'watermark', '', 3, 10);]
Result: Duplicate entry '90' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (91, 'setting91', 'userdel', 'yes', 12, 2);]
Result: Duplicate entry '91' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (93, 'setting93', 'reqregister', 'no', 9, 8);]
Result: Duplicate entry '93' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (101, 'setting101', 'displaynew', 'no', 7, 3);]
Result: Duplicate entry '101' for key 'PRIMARY'
Database:******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (104, 'setting104', 'getoptional', 'yes', 2, 8);]
Result: Duplicate entry '104' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (115, 'setting115', 'dispviews', 'yes', 12, 5);]
Result: Duplicate entry '115' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (116, 'setting116', 'dispdate', 'yes', 13, 5);]
Result: Duplicate entry '116' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (118, 'setting118', 'dispkeys', 'yes', 15, 5);]
Result: Duplicate entry '118' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (119, 'setting119', 'dispdesc', 'yes', 16, 5);]
Result: Duplicate entry '119' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (121, 'setting121', 'disptitle', 'yes', 18, 5);]
Result: Duplicate entry '121' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (122, 'setting122', 'numdays', '1', 19, 5);]
Result: Duplicate entry '122' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (130, 'setting130', 'theme', 'colonial', 6, 9);]
Result: Duplicate entry '130' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (135, 'setting135', 'displayonline', 'yes', 60, 2);]
Result: Duplicate entry '135' for key 'PRIMARY'
Database:******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (142, 'setting142', 'acceptimg', '.jpg,.jpeg,.png,.gif', 89, 3);]
Result: Duplicate entry '142' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (144, 'setting144', 'sidebar', 'left', 1, 11);]
Result: Duplicate entry '144' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (143, 'setting143', 'thumbborder', 'thumbnail', 9, 9);]
Result: Duplicate entry '143' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (145, 'setting145', 'sidebar_width', '20%', 4, 11);]
Result: Duplicate entry '145' for key 'PRIMARY'
Database: ******

Step 3: MySQL error reported: [INSERT INTO settings VALUES (146, 'setting146', 'undercat', 'no', 5, 11);]
Result: Duplicate entry '146' for key 'PRIMARY'
Database: joe_crow

Step 3: MySQL error reported: [CREATE TABLE bids ( id int(2) NOT NULL auto_increment, ad_id int(12) NOT NULL default '0', user_id int(12) NOT NULL default '0', username varchar(128) NOT NULL default '', bid float(12,2) NOT NULL default '0.00', maxbid float(12,2) NOT NULL default '0.00', bid_date int(12) NOT NULL default '0', bid_ip varchar(16) default NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: Table 'bids' already exists
Database: ******

Step 3: MySQL error reported: [CREATE TABLE zipData (zipcode varchar(6) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lat varchar(8) NOT NULL default '', lon varchar(8) NOT NULL default '') ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: Table 'zipData' already exists
Database: ******
AND about 50 more entries like these!

Did this happen because I tried to run the install script a second time?
This is a brand new database, would it be in my best interest to delete it and start all over?

Help please. :o

EXPOSED March 27th, 2009 08:59 PM
and when I try to go to my classifieds at http://thecrowsview.com/classifieds/

This is what I get -
Quote:
Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /home/joe/public_html/classifieds/header-inc.php on line 47

Warning: require(./global.php) [function.require]: failed to open stream: No such file or directory in /home/joe/public_html/classifieds/header-inc.php on line 48

Warning: require(./global.php) [function.require]: failed to open stream: No such file or directory in /home/joe/public_html/classifieds/header-inc.php on line 48

Fatal error: require() [function.require]: Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/joe/public_html/classifieds/header-inc.php on line 48

Chuck S March 27th, 2009 09:09 PM
You ran the install more than once thats what duplicate errors mean.

as far as the second error common mistake on install see this thread number 2

http://www.photopost.com/forum/photo...solutions.html

EXPOSED March 27th, 2009 09:26 PM
Thank you Chuck. I completely missed the part about editing the config_intc.php file!

Now that that is all cleared up, I went to my photopost classifieds at Main Index - PhotoPost Classifieds and got this -

Quote:
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT amt_sold,ads_sold FROM stats

Result: Unknown column 'amt_sold' in 'field list'

Database handle: Resource id #20
Help?

Chuck S March 28th, 2009 06:57 AM
Did you run through the install all the way?

Code:
Content visible to verified customers only.
These queries are right in the install file when install is ran.

Chuck S March 28th, 2009 06:58 AM
You can manually do the queries into the database

CREATE TABLE cp_stats (id int(2) NOT NULL auto_increment, amt_sold float(12,2) NOT NULL default '0', ads_sold int(12) NOT NULL default '0', lastupdate INT(12) NOT NULL default '0', PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO cp_stats VALUES (1, 0, 0, 0);

EXPOSED March 28th, 2009 08:16 AM
As far as I know I did... I got a message that said "your installation is now complete" or something like that.

a query? oh gawd.... where do I do that at? I've never done a query :(

Chuck S March 28th, 2009 11:14 AM
Is your classifieds tables in your vb database is so then run that in the sql manager in vb maintenance tab

EXPOSED March 28th, 2009 04:35 PM
Yes it is. So put all of this in that box?

CREATE TABLE cp_stats (id int(2) NOT NULL auto_increment, amt_sold float(12,2) NOT NULL default '0', ads_sold int(12) NOT NULL default '0', lastupdate INT(12) NOT NULL default '0', PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO cp_stats VALUES (1, 0, 0, 0);

Chuck S March 28th, 2009 04:48 PM
Correct my friend. Just make sure in your vb config file on the canrunqueries line your userid is in that line ;)

EXPOSED March 29th, 2009 08:38 AM
Well, in doing the above, I got this error -

Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'INSERT INTO cp_stats VALUES (1, 0, 0, 0)' at line 3
What now :(

Chuck S March 29th, 2009 03:47 PM
INSERT INTO cp_stats VALUES (1, 0, 0, 0);

There should be no error with that query if the create table one worked.

You can mail to the contact link server info to us.

EXPOSED March 29th, 2009 05:46 PM
The table one did work, but this one isn't. I'm still getting this error when trying to access the classifieds -

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT amt_sold,ads_sold FROM stats

Result: Unknown column 'amt_sold' in 'field list'

Database handle: Resource id #20

Chuck S March 29th, 2009 07:40 PM
That query could not have worked. amt_sold you can see is clearly there in the query I gave.

I may need to see this database because the error makes no sense.

EXPOSED March 29th, 2009 08:14 PM
Ok. How do I show you the database?

Chuck S March 29th, 2009 08:30 PM
You can send server details through the contact link in our header. ;)

EXPOSED March 29th, 2009 10:11 PM
I'm on shared hosting. What info will you need? cPanel login?

Chuck S March 30th, 2009 08:33 AM
Cpanel will work fine.

EXPOSED March 30th, 2009 12:15 PM
I sent you a message through contact us.

Thank you for your help.

Chuck S March 30th, 2009 02:28 PM
Thanks I will let you know via email then


All times are GMT -5. The time now is 07:24 PM.
Page 1 of 4 1 234
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97