search

EVE-SECURE / joomla-in-eve

Automatically exported from code.google.com/p/joomla-in-eve
0 stars 0 forks source link

Error Importing install.sql from com_evecharsheet-0.6.256 #38

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
I've got a little issue here. 

When importing the sql file via phpmyadmin for the (com_evecharsheet-0.6.256)

I receive the following error:
[quote]
SQL query:

INSERT IGNORE INTO #__eve_roles (`roleID`, `roleName`) VALUES (1, 
'roleDirector'), -- (2, ''), -- (4, ''), -- (8, ''), -- (16, ''), -- (32, ''), 
-- (64, ''), (128, 'rolePersonnelManager'), (256, 'roleAccountant'), (512, 
'roleSecurityOfficer'), (1024, 'roleFactoryManager'), (2048, 
'roleStationManager'), (4096, 'roleAuditor'), (8192, 'roleHangarCanTake1'), 
(16384, 'roleHangarCanTake2'), (32768, 'roleHangarCanTake3'), (65536, 
'roleHangarCanTake4'), (131072, 'roleHangarCanTake5'), (262144, 
'roleHangarCanTake6'), (524288, 'roleHangarCanTake7'), (1048576, 
'roleHangarCanQuery1'), (2097152, 'roleHangarCanQuery2'), (4194304, 
'roleHangarCanQuery3'), (8388608, 'roleHangarCanQuery4'), (16777216, 
'roleHangarCanQuery5'), (33554432, 'roleHangarCanQuery6'), (67108864, 
'roleHangarCanQuery7'), (134217728, 'roleAccountCanTake1'), (268435456, 
'roleAccountCanTake2'), (536870912, 'roleAccountCanTake3'), (1073741824, 
'roleAccountCanTake4'), (2147483648, 'roleAccountCanTake5'), (4294967296, 
'roleAccountCanT[...]

MySQL said: Documentation
#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 '(1, 
'roleDirector'),
-- (2, ''),
-- (4, ''),
-- (8, ''),
-- (16, ''),
-- (32, ''' at line 2 
[/quote]

On the website under the Administration/Components/Eve Character Sheet the 
follow errors are displayed:
[quote]
Table `invTypes` found
Table `invGroups` found
Table `chrAttributes` found
Table `crtCertificates` is missing
Table `crtClasses` is missing
Table `crtCategories` is missing
Table `dgmAttributeTypes` found
Table `dgmTypeAttributes` found
Table `staStations` found
[/quote]

I'm assuming the missing items are due to a failure while attempting to import 
the sql file into the database. I've downloaded the file from 
"http://code.google.com/p/joomla-in-eve/downloads/detail?name=com_evecharsheet-0
.6.256.zip&can=2&q=" directly to both the server and a desktop, but attempting 
to import the file results in the same error listed above.

Any insight would be appreciated. 

Thank you,

V/R..

Fasttracks0.

Original issue reported on code.google.com by Fasttrac...@gmail.com on 13 Mar 2011 at 7:55

GoogleCodeExporter commented 9 years ago 
com_evecharsheet-0.6.256 still creates the above listed issue. However, after 
importing the dump files via SOURCE command and an ssh session everything is 
fine except the wallet of players even with full API.

Original comment by Fasttrac...@gmail.com on 3 Apr 2011 at 6:57

GoogleCodeExporter commented 9 years ago 
You have to replace "#_" with "jos", or whatever prefix you use for your Joomla 
installation. 

When you install component using Joomla admin backend, it's done automatically.

Original comment by koval...@gmail.com on 5 Jun 2011 at 12:30