thehamzan6 Queen
Posts: 5 Rep Level: 0 |
Hello,
Dear OneCms members.
I have a problem while installing. It keeps on saying
install.php?step=2
( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:wampwwwinstall.php on line 1233
install.php?step=4
( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:wampwwwinstall.php on line 1636
I'm using OneCms 2.6.4, Php 5.3.8, SQL 5.1
Help please, and admin, send me another message to my inbox, because I don't reply back and I forget. :l
P.S: I changed from xampp to wamp. Because xampp is crap. ---------------
|

Back to Top | |
Mehar King
 Posts: 39 Rep Level: 2 |
Interesting error, if possible, do you get the same error using an XAMPP server? ---------------
|

Back to Top | |
thehamzan6 Queen
Posts: 5 Rep Level: 0 |
In xampp I get deprecated errors. Even if I use the error_reporting & ~deprecated code thingy, it still shows me the deprecated errors. Then I switched back to wamp again, and it worked perfectly fine. I tried to downgrade to php 5.2.x and it still didn't work on xampp.
On wamp, It's all perfectly fine. But I still get that mysql_error thing.
Can you please fix? Thanks.
EDIT:
I get errors in step 5
onecms.profile is not a table in my database.
Help? D: ---------------
|

Back to Top | |
Mehar King
 Posts: 39 Rep Level: 2 |
In your database can you check to see if there is a table called onecms_profile?
If not, run this code in the SQL area,
| Code: | CREATE TABLE `onecms_profile` ( `id` int(11) NOT NULL auto_increment, `username` text, `aim` text, `msn` text, `yahoo` text NOT NULL, `icq` text NOT NULL, `gtalk` text NOT NULL, `birthday` text NOT NULL, `website` text, `nickname` text, `location` text, `sig` text, `avatar` text, PRIMARY KEY `id` (`id`), FULLTEXT KEY `username` (`username`,`aim`,`msn`,`website`,`nickname`,`location`), FULLTEXT KEY `sig` (`sig`,`avatar`)) |
---------------
|

Back to Top | |
thehamzan6 Queen
Posts: 5 Rep Level: 0 |
#1214 - The used table type doesn't support FULLTEXT indexes
This error displayed. Is it because I'm using mysqli?
-----------------------------------------------------
EDIT:
Never mind. I fixed it by adding " ) AUTO_INCREMENT=1 ENGINE = MYISAM; "
SQL QUERY TEXT:
CREATE TABLE `onecms_profile` ( `id` int(11) NOT NULL auto_increment, `username` text, `aim` text, `msn` text, `yahoo` text NOT NULL, `icq` text NOT NULL, `gtalk` text NOT NULL, `birthday` text NOT NULL, `website` text, `nickname` text, `location` text, `sig` text, `avatar` text, PRIMARY KEY `id` (`id`), FULLTEXT KEY `username` (`username`,`aim`,`msn`,`website`,`nickname`,`location`), FULLTEXT KEY `sig` (`sig`,`avatar`) ) AUTO_INCREMENT=1 ENGINE = MYISAM;
-------------------------------- EDIT:
Now, I got this error in step 5 "Table 'hamzan.onecms_pm' doesn't exist" >.<
Please e-mail me again. I need this urgently.
---------------
|

Back to Top | |
Mehar King
 Posts: 39 Rep Level: 2 |
That new error means your pm table is missing, interesting, I can't say I've ever come across an install issue like this before. To fix it though simply run the following in your SQL,
| Code: | |
CREATE TABLE `onecms_pm` ( `id` int(11) NOT NULL auto_increment, `viewed` text, `subject` text, `message` text, `who` text, `jo` text, `date` text, `box` text NOT NULL, PRIMARY KEY `id` (`id`), KEY `id` (`id`), FULLTEXT KEY `viewed` (`viewed`), FULLTEXT KEY `subject` (`subject`), FULLTEXT KEY `message` (`message`), FULLTEXT KEY `who` (`who`), FULLTEXT KEY `jo` (`jo`), FULLTEXT KEY `date` (`date`))
|
---------------
|

Back to Top | |