Support

 I am trying to restore a .jpa file to localhost running wamp 3.0.0 on win7 64bit
kickstart extracts fine.
When it comes to db restoration I get ErrNo #0

 SQL=CREATE TABLE `jfwiq_ak_profiles` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `description` varchar(255) NOT NULL,   `configuration` longtext,   `filters` longtext,   `quickicon` tinyint(3) NOT NULL DEFAULT '1',   PRIMARY KEY (`id`) ) ENGINE=Aria AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1

I tried replacing the 'ENGINE=Aria' part with "", but it did not work.

importing a sql dump into local phpmyadmin results in the same error.

How can I get the db running on localhost, please?

Best,

Thomas

Hi Davide,

thanks for the quick reply.

I replaced Aria with MyISAM and imported directly into phpmyadmin on localhost.

Here is what I get:

SQL query:


CREATE TABLE `jfwiq_ak_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) NOT NULL,
  `configuration` longtext,
  `filters` longtext,
  `quickicon` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1
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 'PAGE_CHECKSUM=1' at line 8

must be something else.
what do we try next?

thx

I removed the PAGE_CHECKSUM and phpmyadmin now imports the.sql file.
However, this takes forever ( I had to extend the maximum execution time) and the import stops half way through the tables.
File size is only 2305 KB.
So this looks like a problem with local phpmyadmin.

The strange thing is, that I can restore the .jpa file without problem on the live server.

Any thoughts?

Update
I managed to import edited (PAGE_CHECKSUM removed from extracted .jba file db) .sql file into local myphpadmin.

edited configuration.php to point to above db name.
Now I get db connection error

Application Instantiation Error: Table 'db.prefix_session' doesn't exist

I have set
public $db = 'beauchamp7'; (the db I imported into in step 1)
public $host = 'localhost';
public $user = 'root';
public $password = '';

How can I get past this?

looking forward to your reply :)

T

update

site.sql last line is at table 'm'

no wonder table session does not exist.

Looks like extracted site.sql from .jpa file is incomplete.

Perhaps time to rewrite the site from scratch

Thanks Davide,

I will try that.

Greetings to Italy from Austalia :)

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.