Page 1 of 2
Import data
Posted: 05 Oct 2018, 17:42
by 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?
Re: Import data
Posted: 06 Oct 2018, 12:08
by 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
Re: Import data
Posted: 06 Oct 2018, 12:16
by Jan
Hi, just comment this row and run the sql queries again.
Jan
Re: Import data
Posted: 06 Oct 2018, 13:49
by wimpie
Hello Jan
I don't understand what you maen.
Re: Import data
Posted: 06 Oct 2018, 19:08
by 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
Re: Import data
Posted: 06 Oct 2018, 19:20
by 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
Re: Import data
Posted: 06 Oct 2018, 20:18
by 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.
Re: Import data
Posted: 09 Oct 2018, 19:34
by 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
Re: Import data
Posted: 09 Oct 2018, 19:50
by 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
Re: Import data
Posted: 11 Oct 2018, 00:51
by 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