Log in
Subscribe Now!Subscription:
$99/6 months - $149/12 months
Had a positive JobGrok experience?
Leave us a review here.
 JobGrok
Welcome Guest   [Register]  [Login]
 Subject :SQL Errors.. 2009-11-11 04:36:47 
meridianblade
Fresh Boarder
Joined: 2009-11-10 17:38:30
Posts: 1
Location

Hello,

I'm trying to install this and im getting the following SQL error and it then fails.

 

  • JInstaller::install: SQL Error. DB function failed with error number 1005
    Can't create table './coccadevelopment/jos_tst_jglist_static_category.frm' (errno: -1) SQL=CREATE TABLE IF NOT EXISTS `jos_tst_jglist_static_category` ( `id` Int NOT NULL AUTO_INCREMENT, `category` TEXT NOT NULL, PRIMARY KEY(id)) TYPE=InnoDB CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
    SQL =
    CREATE TABLE IF NOT EXISTS
    `jos_tst_jglist_static_category` (
    `id` Int NOT NULL AUTO_INCREMENT,
    `category` TEXT NOT NULL,
    PRIMARY KEY(id)) TYPE=InnoDB
    CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
  • Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1005
    Can't create table './coccadevelopment/jos_tst_jglist_static_category.frm' (errno: -1) SQL=CREATE TABLE IF NOT EXISTS `jos_tst_jglist_static_category` ( `id` Int NOT NULL AUTO_INCREMENT, `category` TEXT NOT NULL, PRIMARY KEY(id)) TYPE=InnoDB CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
    SQL =
    CREATE TABLE IF NOT EXISTS
    `jos_tst_jglist_static_category` (
    `id` Int NOT NULL AUTO_INCREMENT,
    `category` TEXT NOT NULL,
    PRIMARY KEY(id)) TYPE=InnoDB
  • CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

Also Application gives me the following error in the /Application/ Menu:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/rdetwiler/coccadevelopment.com/libraries/joomla/database/database/mysql.php on line 344

 

Any ideas?

Thanks!

IP Logged
Page # 


Powered by ccBoard


Search