...

View Full Version : Installing PHPFox



mafenman
12-30-2005, 03:54 AM
Yes, I am currently installing PHPFox onto my website but i am currently having a bit of a hassle getting it to work.


Created Config File "site_config.php": OK
Created Config Backup File "site_config_backup.php": OK
/gallery/I/ is writable: Yes
/gallery/I/2005/ is writable: Yes
/gallery/I/2005/01/ is writable: Yes
/gallery/I/2005/01/01/ is writable: Yes
/gallery/I/2005/01/01/thumb/ is writable: Yes
/user/bg/ is writable: Yes
/user/bg/2005/ is writable: Yes
/user/bg/2005/01/ is writable: Yes
/user/bg/2005/01/01/ is writable: Yes
/member/i/ is writable: Yes
/member/i/p/ is writable: Yes
/member/i/p/2005/ is writable: Yes
/member/i/p/2005/01/ is writable: Yes
/groups/gallery/ is writable: Yes
/groups/gallery/2005/ is writable: Yes
/groups/gallery/2005/01/ is writable: Yes
/groups/gallery/2005/01/thumb/ is writable: Yes
Mysql Table Created ( 0 / 43): FAIL

Here it is, It fails to create the Mysql tables.
If anyone can tell me how to fix this It would be a great help.

Velox Letum
12-30-2005, 08:53 AM
How vague. Despite this, it would appear that your MySQL connection information in one of the configuration files was most likely improperly set. If the connection information is correct, you might try creating the database. If it already is created, possibly it's trying to create it again and failing, in that case delete the database.

intime
01-13-2006, 08:35 PM
for someone with 1,000 plus post, the response was ignorant and unnecessary

anywho, the FIX is

you must edit the phpfox.sql file

example:

CREATE TABLE `adds` (
`id` int(11) NOT NULL auto_increment,
`text` text collate latin1_general_ci NOT NULL,
`type` tinytext collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ;

must become

CREATE TABLE `adds` (
`id` int(11) NOT NULL auto_increment,
`text` text NOT NULL,
`type` tinytext NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

just do a search and replace for "engine=myisam default charset" and "collate latin1_general_ci", etc...
also there are 2 "collate=latin1", so search for that also

ralph l mayo
01-13-2006, 09:04 PM
for someone with 1,000 plus post, the response was ignorant and unnecessary

Yeah, aren't you required to know about every bugfix for J. Random PHP CMS after post #400? Take your common sense diagnosis of possible MySQL problems and cludgy old non-psychic need for context in order to solve problems elsewhere. :rolleyes:



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum