LoginRegister Welcome Guest!

Your Ad Here
OneCMS :: Viewing Topic - Another Install error
Home > Bugs & Fixes    

thehamzan6
Queen

Posts: 5
Rep Level: 0
Posted: 11-17-11 11:31 AMSubject: Another Install error

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
Posted: 11-18-11 09:11 PMSubject: Re: Another Install error

Interesting error, if possible, do you get the same error using an XAMPP server?


---------------


Back to Top
         
thehamzan6
Queen

Posts: 5
Rep Level: 0
Posted: 11-19-11 03:33 AMSubject: Re: Another Install error

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
Posted: 11-19-11 10:47 AMSubject: Re: Another Install error

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
Posted: 11-21-11 10:34 AMSubject: Re: Another Install error

#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
Posted: 11-22-11 09:49 PMSubject: Re: Another Install error

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
         
^Last Login: Logged in for: Skin: Forum Jump: