ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down.
Read our Farewell Blog Post for more details.
SOLVED :( NEED HELP....Database ERROR
-
-
- TilenVonHarc
- Elite Rocketeer
- Posts: 674
- Thanks: 13
-
Hello!
I have the template Refraction 2009.
And I had several problems. The first was that I could not complete the joomla installation, because I hade to change in the php the type with engine.... Hello?? And I found the solution on the forum...you should repair the package that is availible to download...
Now the second problem....when I want to import my MySQL database I get this:
Error
SQL query:
--
--
-- Table structure for table `jos_core_acl_aro`
--
CREATE TABLE `jos_core_acl_aro` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`section_value` varchar( 240 ) NOT NULL DEFAULT '0',
`value` varchar( 240 ) NOT NULL DEFAULT '',
`order_value` int( 11 ) NOT NULL DEFAULT '0',
`name` varchar( 255 ) NOT NULL DEFAULT '',
`hidden` int( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `jos_section_value_value_aro` ( `section_value` ( 100 ) , `value` ( 100 ) ) ,
KEY `jos_gacl_hidden_aro` ( `hidden` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 DATA DIRECTORY = './zds/' INDEX DIRECTORY = './zds/' AUTO_INCREMENT =11;
MySQL said: Documentation
#1103 - Incorrect table name './zds/'
Please help.... - Last Edit: 13 years 8 months ago by TilenVonHarc.
- Tilen
-
-
-
- prim
- Preeminent Rocketeer
- Posts: 17290
- Thanks: 217
-
I'm not really sure what you are trying to do here but have you tried these 2 tools?
www.akeebabackup.com
sourceforge.net/projects/automysqlbackup/ - Please reply with a direct link to the issue & create a new thread for each new issue.
A template is only as good as the content that goes into it
- DanG
-
-
-
- TilenVonHarc
- Elite Rocketeer
- Posts: 674
- Thanks: 13
-
Now I tried on anothger free web host site...because I have to show the stages to my client...
and i get this:
sql200.000space.com - space_9014363_ZDS
Error
SQL query:
--
-- Database: `ZDS`
--
--
--
-- Table structure for table `bak_core_acl_aro`
--
CREATE TABLE `bak_core_acl_aro` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`section_value` varchar( 240 ) NOT NULL DEFAULT '0',
`value` varchar( 240 ) NOT NULL DEFAULT '',
`order_value` int( 11 ) NOT NULL DEFAULT '0',
`name` varchar( 255 ) NOT NULL DEFAULT '',
`hidden` int( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `jos_section_value_value_aro` ( `section_value` ( 100 ) , `value` ( 100 ) ) ,
KEY `jos_gacl_hidden_aro` ( `hidden` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =11;
MySQL said: Documentation
#1050 - Table 'bak_core_acl_aro' already exists
[ Back ]
And I do not understand what you mean with: I'm not really sure what you are trying to do here but have you tried these 2 tools?
I am trying to IMPORT my database from my localhost to the web.... and I get this 2 errors...
I am wondering...why does the site work on my PC (localhost) and not on the web....
please help me... - Tilen
-
-
-
- prim
- Preeminent Rocketeer
- Posts: 17290
- Thanks: 217
-
1. I do not understand why you want to import the database in the first place. If you are trying to backup your site, use Akeeba.
2. If you want to do a proper import of the database then you need a good/working copy of the database. That is why i showed those 2 tools.
3. When i Googled about that error, sometimes it's related to a bad update of Joomla or something is up with the ACL. - Please reply with a direct link to the issue & create a new thread for each new issue.
A template is only as good as the content that goes into it - DanG
-
-
-
- TilenVonHarc
- Elite Rocketeer
- Posts: 674
- Thanks: 13
-
Yes...i want to transfer the modifiet sql to the web. I did this once before with a rockettheme template and there were no problems...i think that the tamplate has problems...like the one with installing where i had to change the type to engine in the php...
What to do?
The site works perfect on my localhost so i doubt there is a problem with the database... - Tilen
-
-
-
- prim
- Preeminent Rocketeer
- Posts: 17290
- Thanks: 217
- Since you already have working backups (as you say) try dropping the tables on the database on the server or make a new database.
- Please reply with a direct link to the issue & create a new thread for each new issue.
A template is only as good as the content that goes into it - DanG
-
-
-
- TilenVonHarc
- Elite Rocketeer
- Posts: 674
- Thanks: 13
-
After I make a new database (which I have to do everytime I transfered it to tge server) this is the problem! The first error occured on the 000webhosting page, the second on another. the first error saif that ZDS (name of the DB) in not a valid name - please see post above about the error...
BTW, this is the first databs that have BAK and JOS table prefixes..and the BAK were transfered the first time...the JOS not - Tilen
-
-
-
- TilenVonHarc
- Elite Rocketeer
- Posts: 674
- Thanks: 13
- Hello?? Anybody? It is really urgent....
- Tilen
-
-
-
- prim
- Preeminent Rocketeer
- Posts: 17290
- Thanks: 217
-
BAK usually means backup...
Do you really have a database called ZDS on the new server? - Please reply with a direct link to the issue & create a new thread for each new issue.
A template is only as good as the content that goes into it - DanG
-
Time to create page: 0.088 seconds