PhotoPost Community

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

Toxiedog March 2nd, 2006 12:58 PM

Database error
 
I am getting the following message when attempting to install PhotoPost Classifieds:
Step 3: MySQL error reported: [CREATE TABLE zipData (zipcode varchar(5) 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', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM]
Result: Table 'zipData' already exists
Database: bidsness_community

Any suggestions? I'm running vBulletin 3.5.3 and the latest version of PhotoPost Classifieds. I also have ReviewPost installed in the vBulletin database.

Toxiedog March 2nd, 2006 01:07 PM

And on step 5 I am getting the following error messages

Warning: fopen(/home/bidsness/public_html/community/classifieds/data/1/thumbs/index.htm): failed to open stream: Permission denied in /home/bidsness/public_html/community/classifieds/install.php on line 996

Warning: fclose(): supplied argument is not a valid stream resource in /home/bidsness/public_html/community/classifieds/install.php on line 997

Warning: fopen(/home/bidsness/public_html/community/classifieds/data/1/large/index.htm): failed to open stream: Permission denied in /home/bidsness/public_html/community/classifieds/install.php on line 1002

Warning: fclose(): supplied argument is not a valid stream resource in /home/bidsness/public_html/community/classifieds/install.php on line 1003

Warning: fopen(/home/bidsness/public_html/community/classifieds/data/2/thumbs/index.htm): failed to open stream: Permission denied in /home/bidsness/public_html/community/classifieds/install.php on line 996

Warning: fclose(): supplied argument is not a valid stream resource in /home/bidsness/public_html/community/classifieds/install.php on line 997

Warning: fopen(/home/bidsness/public_html/community/classifieds/data/2/large/index.htm): failed to open stream: Permission denied in /home/bidsness/public_html/community/classifieds/install.php on line 1002

Warning: fclose(): supplied argument is not a valid stream resource in /home/bidsness/public_html/community/classifieds/install.php on line 100

Chuck S March 2nd, 2006 02:03 PM

Okay well post 1 is not an issue it is just telling you that the table already exists since you installed it with reviewpost

Now as to post 2 per the installation instructions you want to chmod your data directory and all its children at every level to 777


All times are GMT -5. The time now is 12:41 AM.

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