sql error

[infinita]

On install i getting this:


A Database Error Occurred

Error Number: 1115

Unknown character set: 'ucs2'

CREATE TABLE `site_settings` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `value` text character set ucs2, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1

Any ideas what wrong 

[Mihail Chepovskiy]

I am so sorry, can't understand how this line has creeped in the installer.
I am renewed it, download one more time, please, and reinstall the application.

Regards,
Mihail.

[infinita]

hi again,

Just did it but again see the same:


A Database Error Occurred

Error Number: 1115

Unknown character set: 'ucs2'

CREATE TABLE `system_settings` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `value` text character set ucs2, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1

[infinita]

i have corrected settings.install.sql by myself but seems error still in install package:

...
  `value` text character set ucs2,
...

[infinita]

just after it solved i got next error:

http://www.onwebin.co.uk/install/

Internal Server Error, this is an error with your script, check your error log for more information.

Why can be it?  

it will be as i suppose something wit .htaccess just not sure what to do now..

[Mihail Chepovskiy]

Your server runs PHP as CGI,
read the 2nd note here http://www.salephpscripts.com/manual/installation

Regards,
Mihail.

[Mihail Chepovskiy]

If it doesn't help:

in .htaccess file change the last line to:
RewriteRule ^(.*)$ /index.php/$1

Hope this will helps

[infinita]

same problem remain

at address bar i see now:

http://www.onwebin.co.uk/index.php/install/

but getting same error:

Internal Server Error, this is an error with your script, check your error log for more information.

...

[hands0me]

hi

I installed according to instructions 1-6

7 Go to 'http://mysite/'   :


A Database Error Occurred

Error Number: 1146

Table 'where_db.whe_modules' doesn't exist

INSERT INTO `whe_modules` (`dir`, `name`) VALUES ('settings', 'System and site settings module')


again 7 Go to 'http://mysite/'   :


A Database Error Occurred

Error Number: 1050

Table 'site_settings' already exists

CREATE TABLE `site_settings` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `value` text, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1


if i change to RewriteRule ^(.*)$ index.php/$1 :

Internal Server Error



server :
PHP
CGI on
FastCGI on
$config['index_page'] = "index.php";

any ideas?

thanks

[johncarlson21]

empty your database and start the install over.

[hands0me]

after empty i get the same errors

[Mihail Chepovskiy]

What is your mysql version?

Also check were all files copied in 'modules/modules_control/' folder