Import data

[wimpie]

I'm trying to import the phocagallery datebase in a new website but I got some errors.

Fout
Statische analyse:

2 fouten werden gevonden tijdens de analyse.

Onverwacht begin van opdracht. (near "phpMyAdmin" at position 0)
Opdracht type niet herkent. (near "SQL" at position 11)
SQL-query:

phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"

MySQL meldt: Documentatie

#1064 - Er is iets fout in de gebruikte syntax bij 'phpMyAdmin SQL Dump

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"' in regel 1

What am I doing wrong?

[wimpie]

Hello
Some additional information: I currently use joomla 2.5.28 and phocagallery 3.2.8. PHP 5.6. My provider informed me that from november the first they only use PHP 7.1 and stop PHP 5.6. Joomla 2.5.28 doesn't support php7.1 so I installed in a subdomain joomla 3.8.12 and phocagallery 4.3.10.
So I made an export of my datebase using this link https://www.phoca.cz/documents/50-phoca ... o-joomla-3.
But the import gave some errors. Hope that someone can help me.

My website wimwesterhof.nl

[Jan]

Hi, just comment this row and run the sql queries again.

Jan

[wimpie]

Hello Jan
I don't understand what you maen.

[wimpie]

Hello Jan,

This is a part of the database

-- phpMyAdmin SQL Dump
-- version 4.6.6deb4
-- https://www.phpmyadmin.net/
--
-- Host: db.wimwesterhof.nl
-- Gegenereerd op: 04 okt 2018 om 19:40
-- Serverversie: 10.2.12-MariaDB-log
-- PHP-versie: 7.0.30-0+deb9u1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

I don't know what's wrong in here

[Jan]

Just comment this line:
FROM:

Code: Select all

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

TO:

Code: Select all

-- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

so it will be ignored when running the sql query. (Why the database has problems with this query, hard to say, this is much more a question on webhosting/database provider )

Jan

[wimpie]

Hello Jan,
It doesn't work.

2 fouten werden gevonden tijdens de analyse.

Onverwacht begin van opdracht. (near "phpMyAdmin" at position 0)
Opdracht type niet herkent. (near "SQL" at position 11)
SQL-query:

phpMyAdmin SQL Dump SET time_zone = "+00:00"

MySQL meldt: Documentatie

#1064 - Er is iets fout in de gebruikte syntax bij 'phpMyAdmin SQL Dump
SET time_zone = "+00:00"' in regel 1

-- phpMyAdmin SQL Dump
-- version 4.6.6deb4
-- https://www.phpmyadmin.net/
--
-- Host: db.wimwesterhof.nl
-- Gegenereerd op: 04 okt 2018 om 19:40
-- Serverversie: 10.2.12-MariaDB-log
-- PHP-versie: 7.0.30-0+deb9u1
-- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

I tried the same with set time_zone. Changed it in -- set time zone but it doesn't work.
Any idea what is wrong.

[Jan]

Hi, I think, this is much more a question on your webhosting provider, really no idea what could be wrong there as there are just standard basic queries

Jan

[wimpie]

Hello Jan,
I already asked my provider, but until now I got no answer.
Just another question. In my database is a string with j25 files and one with jos files. Do I need to export both or only the jos files.

wim

[Jan]

Hi, hard to say, maybe jos is some obsolete table (not more used) (in case the j25 and jos are the prefixes of the tables stored in your database)

Jan