google-code-export / glossword

Automatically exported from code.google.com/p/glossword
0 stars 0 forks source link

Component installation returning mysql error. #139

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
= What steps will reproduce the problem?
1. I am trying to install the latest version of glossword on joomla 1.5.15 and 
it is returning the 
following mysql error.

I am trying to install the latest version of the glossword on joomla 1.5.15 but 
it is returning 
following error.

JInstaller::install: SQL Error. DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your 
MySQL server 
version for the right syntax to use near 'COMPACT' at line 11 SQL=CREATE TABLE 
IF NOT EXISTS 
`jos_gw_sessions_jos` ( `id_sess` char(32) NOT NULL, `id_user` int(10) unsigned 
NOT NULL 
DEFAULT '1', `is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1', `mdate` 
datetime NOT 
NULL, `sess_settings` blob, `ip` int(10) unsigned NOT NULL DEFAULT '0', `ua` 
varchar(255) 
NOT NULL, PRIMARY KEY (`id_sess`), KEY `changed` (`mdate`) ) ENGINE=MyISAM 
DEFAULT 
CHARSET=utf8 ROW_FORMAT=COMPACT;
SQL =
CREATE TABLE IF NOT EXISTS `jos_gw_sessions_jos` (
  `id_sess` char(32) NOT NULL,
  `id_user` int(10) unsigned NOT NULL DEFAULT '1',
  `is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `mdate` datetime NOT NULL,
  `sess_settings` blob,
  `ip` int(10) unsigned NOT NULL DEFAULT '0',
  `ua` varchar(255) NOT NULL,
  PRIMARY KEY (`id_sess`),
  KEY `changed` (`mdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
Component Install: SQL error or missing or unreadable SQL file. DB function 
failed with error 
number 1064
You have an error in your SQL syntax; check the manual that corresponds to your 
MySQL server 
version for the right syntax to use near 'COMPACT' at line 11 SQL=CREATE TABLE 
IF NOT EXISTS 
`jos_gw_sessions_jos` ( `id_sess` char(32) NOT NULL, `id_user` int(10) unsigned 
NOT NULL 
DEFAULT '1', `is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1', `mdate` 
datetime NOT 
NULL, `sess_settings` blob, `ip` int(10) unsigned NOT NULL DEFAULT '0', `ua` 
varchar(255) 
NOT NULL, PRIMARY KEY (`id_sess`), KEY `changed` (`mdate`) ) ENGINE=MyISAM 
DEFAULT 
CHARSET=utf8 ROW_FORMAT=COMPACT;
SQL =
CREATE TABLE IF NOT EXISTS `jos_gw_sessions_jos` (
  `id_sess` char(32) NOT NULL,
  `id_user` int(10) unsigned NOT NULL DEFAULT '1',
  `is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `mdate` datetime NOT NULL,
  `sess_settings` blob,
  `ip` int(10) unsigned NOT NULL DEFAULT '0',
  `ua` varchar(255) NOT NULL,
  PRIMARY KEY (`id_sess`),
  KEY `changed` (`mdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

I am using mysql 4.1.25.

= What is the expected output? What do you see instead?

= What version of the product are you using? On what operating system?

= Please provide any additional information below.

Original issue reported on code.google.com by bagerat...@gmail.com on 17 Mar 2010 at 11:18

GoogleCodeExporter commented 9 years ago
Replace file `admin/glossword_1_9.structure.sql` inside installation package 
and try
again.

Original comment by dmitry.s...@gmail.com on 17 Mar 2010 at 2:18

Attachments:

GoogleCodeExporter commented 9 years ago
Worked for me, I had the same issue.

Original comment by marcin.m...@gmail.com on 20 Mar 2010 at 5:40

GoogleCodeExporter commented 9 years ago
Hi,

I am using joomla 1.5.10, mysql 5.051b, php 5.2.6 and tried to install
glossword-1.9.3--component--joomla.zip. I got the error 

JInstaller::install: SQL Error. DB function failed with error number 1146
Table 'hiop.jos_gw_tv' doesn't exist SQL=INSERT INTO `jos_gw_tv` (`id_tv`, 
`id_lang`, ...

and after replacing the file mentioned above I got

JInstaller::install: SQL Error. DB function failed with error number 1062
Duplicate entry '186' for key 1 SQL=INSERT INTO `jml_gw_az_letters` 
(`id_letter`,
`id_lang`, `uc_crc32u`, `int_sort`, `uc`, `lc`) VALUES (186, 876608490, 
3554254475,
10, 'A', 'a'), (187, 876608490, 1255198513, 20, 'B', 'b'), (188, 876608490 ...

Original comment by zipfelmu...@gmail.com on 7 Apr 2010 at 9:04

GoogleCodeExporter commented 9 years ago
The file above is for 1.9.2.

I checked sql-files for jos_gw_tv and found it :( 

So replace file `admin/glossword_1_9_tv.sql` inside installation package and try
again

Original comment by dmitry.s...@gmail.com on 7 Apr 2010 at 9:26

Attachments:

GoogleCodeExporter commented 9 years ago
Hi there,

I get related Error message when installing 1.9.2 or 1.9.3.1. But I get it after
installation and configuration. 

Error meaasege is: 
MySQL Error
Error Number: 1146
Table 'mydatabase_wYtTpjo.jos_gw_settings' doesn't exist
SELECT * FROM (`jos_gw_settings`) 

Error message appears when I click on "Control Panel"

As error message is same "1146" I decided to post it in here and not to make 
another
thread.

My Joomla is 1.5.17

Thanks in advance!
Alar

Original comment by syntetic...@gmail.com on 9 May 2010 at 8:45

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
I'm getting a different MYSQL error  after I install glossworld:

MySQL Error
Error Number: 1264
Out of range value for column 'ip' at row 1
INSERT INTO `jos_gw_sessions_jos` (`id_sess`, `ip`, `ua`, `id_user`, 
`is_remember`, `mdate`) VALUES ('7641a42e70d0f76dc2b6954cb39f7808', 
-1154190685, 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) 
AppleWebKit/534.10 (KHTML, like Gecko) Chrome/8.0.552.224 Safari/534.10', '62', 
1, '2011-01-13 11:29:46')

I altered htaccess.txt as the installation required, but when I try to use the 
component I get the above error message...
I'm running Joomla 1.5.

Original comment by duarte...@gmail.com on 13 Jan 2011 at 1:39