Cant Success While Transfreing Old DB Table
- c a g a t a y
- Phoca Member
- Posts: 43
- Joined: 17 Aug 2009, 21:51
Cant Success While Transfreing Old DB Table
Hi there
More than 3 days I cant succes to transfer my old PhocaGuestbook items to new DB
I did what you explained in this page
https://www.phoca.cz/development/50-joom ... o-joomla-3
Is there anyone to change my db tables? I can send my old and new DB tables...Pelase help
Old PhocaGuestbook verison: 2.0.7
New PhocaGuestbook verison: 3.0.6
Best Redads
More than 3 days I cant succes to transfer my old PhocaGuestbook items to new DB
I did what you explained in this page
https://www.phoca.cz/development/50-joom ... o-joomla-3
Is there anyone to change my db tables? I can send my old and new DB tables...Pelase help
Old PhocaGuestbook verison: 2.0.7
New PhocaGuestbook verison: 3.0.6
Best Redads
- c a g a t a y
- Phoca Member
- Posts: 43
- Joined: 17 Aug 2009, 21:51
Re: Cant Success While Transfreing Old DB Table
What I run this query
it turns with this error;
Code: Select all
INSERT `jos_phocaguestbook_items` (id, catid, parent_id, lft, level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time) SELECT id+1 AS id, 10013 AS catid, 1 AS parent_id, ordering AS lft, 1 AS level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time FROM `jos_temp_phocaguestbook_items`
- Jan
- Phoca Hero
- Posts: 47887
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Cant Success While Transfreing Old DB Table
Hi, what program do you use for making the sql queries?
What if you paste the queries in e.g. phpMyAdmin?
What if you manually change the date from "0000-00-00 00:00:00" to some real date "2017-05-19 01:01:01"?
Really hard to say what is wrong in the database with date settings
Jan
What if you paste the queries in e.g. phpMyAdmin?
What if you manually change the date from "0000-00-00 00:00:00" to some real date "2017-05-19 01:01:01"?
Really hard to say what is wrong in the database with date settings
Jan
If you find Phoca extensions useful, please support the project
- c a g a t a y
- Phoca Member
- Posts: 43
- Joined: 17 Aug 2009, 21:51
Re: Cant Success While Transfreing Old DB Table
Hi Jan
Yes i am using phpMyAdmin in my Localhost (using wamp)
I dont understand this part. How can i change? Or where can i change? Within 2.5 DB ???
Regards
- Jan
- Phoca Hero
- Posts: 47887
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Cant Success While Transfreing Old DB Table
Hi, I mean in the source data, in the rows directly in phpMyAdmin which include this date with '00 ...' in checked_out_time column.
Usually, the column "checked_out_time" is still the same, really no idea why you get such an error message?
Jan
Usually, the column "checked_out_time" is still the same, really no idea why you get such an error message?
Jan
If you find Phoca extensions useful, please support the project
- c a g a t a y
- Phoca Member
- Posts: 43
- Joined: 17 Aug 2009, 21:51
Re: Cant Success While Transfreing Old DB Table
Hi Jan
I opened my Joomla 2.5 PhocaGuestbook SQL file in Notepad++ and manuelly changed 0000-00-00 00:00:00" to --> "2017-05-19 01:01:01
I run this query;
And got these errors
(I am in localhost/PhpMyAdmin platform)
I opened my Joomla 2.5 PhocaGuestbook SQL file in Notepad++ and manuelly changed 0000-00-00 00:00:00" to --> "2017-05-19 01:01:01
I run this query;
Code: Select all
INSERT `avsr3_phocaguestbook_items` (id, catid, parent_id, lft, level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time) SELECT id+1 AS id, 10013 AS catid, 1 AS parent_id, ordering AS lft, 1 AS level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time FROM `avsr3_pphocaguestbook_items`
(I am in localhost/PhpMyAdmin platform)
Code: Select all
Error
Static analysis:
34 errors were found during analysis.
Unexpected token. (near "`avsr3_phocaguestbook_items`" at position 7)
Unexpected token. (near "(" at position 36)
Unexpected token. (near "id" at position 37)
Unexpected token. (near "," at position 39)
Unexpected token. (near "catid" at position 41)
Unexpected token. (near "," at position 46)
Unexpected token. (near "parent_id" at position 48)
Unexpected token. (near "," at position 57)
Unexpected token. (near "lft" at position 59)
Unexpected token. (near "," at position 62)
Unrecognized keyword. (near "level" at position 64)
Unexpected token. (near "," at position 69)
Unexpected token. (near "username" at position 71)
Unexpected token. (near "," at position 79)
Unexpected token. (near "userid" at position 81)
Unexpected token. (near "," at position 87)
Unexpected token. (near "email" at position 89)
Unexpected token. (near "," at position 94)
Unexpected token. (near "homesite" at position 96)
Unexpected token. (near "," at position 104)
Unexpected token. (near "ip" at position 106)
Unexpected token. (near "," at position 108)
Unexpected token. (near "title" at position 110)
Unexpected token. (near "," at position 115)
Unexpected token. (near "content" at position 117)
Unexpected token. (near "," at position 124)
Unrecognized keyword. (near "date" at position 126)
Unexpected token. (near "," at position 130)
Unexpected token. (near "published" at position 132)
Unexpected token. (near "," at position 141)
Unexpected token. (near "checked_out" at position 143)
Unexpected token. (near "," at position 154)
Unexpected token. (near "checked_out_time" at position 156)
Unexpected token. (near ")" at position 172)
SQL query: Documentation
INSERT `avsr3_phocaguestbook_items` (id, catid, parent_id, lft, level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time) SELECT id+1 AS id, 10013 AS catid, 1 AS parent_id, ordering AS lft, 1 AS level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time FROM `avsr3_pphocaguestbook_items`
MySQL said: Documentation
#1364 - Field 'path' doesn't have a default value
- Jan
- Phoca Hero
- Posts: 47887
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Cant Success While Transfreing Old DB Table
Hi, the "INTO" is missing there, run this query:
but only after the temp table were done.
Anyway sorry for the typo error in the query, I have fixed it.
Let me know if this works for you.
Thank you, Jan
Code: Select all
INSERT INTO `avsr3_phocaguestbook_items` (id, catid, parent_id, lft, level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time) SELECT id+1 AS id, 10013 AS catid, 1 AS parent_id, ordering AS lft, 1 AS level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time FROM `avsr3_pphocaguestbook_items`
Anyway sorry for the typo error in the query, I have fixed it.
Let me know if this works for you.
Thank you, Jan
If you find Phoca extensions useful, please support the project
- c a g a t a y
- Phoca Member
- Posts: 43
- Joined: 17 Aug 2009, 21:51
Re: Cant Success While Transfreing Old DB Table
returned with these errors
Code: Select all
Error
Static analysis:
34 errors were found during analysis.
Unexpected token. (near "`avsr3_phocaguestbook_items`" at position 7)
Unexpected token. (near "(" at position 36)
Unexpected token. (near "id" at position 37)
Unexpected token. (near "," at position 39)
Unexpected token. (near "catid" at position 41)
Unexpected token. (near "," at position 46)
Unexpected token. (near "parent_id" at position 48)
Unexpected token. (near "," at position 57)
Unexpected token. (near "lft" at position 59)
Unexpected token. (near "," at position 62)
Unrecognized keyword. (near "level" at position 64)
Unexpected token. (near "," at position 69)
Unexpected token. (near "username" at position 71)
Unexpected token. (near "," at position 79)
Unexpected token. (near "userid" at position 81)
Unexpected token. (near "," at position 87)
Unexpected token. (near "email" at position 89)
Unexpected token. (near "," at position 94)
Unexpected token. (near "homesite" at position 96)
Unexpected token. (near "," at position 104)
Unexpected token. (near "ip" at position 106)
Unexpected token. (near "," at position 108)
Unexpected token. (near "title" at position 110)
Unexpected token. (near "," at position 115)
Unexpected token. (near "content" at position 117)
Unexpected token. (near "," at position 124)
Unrecognized keyword. (near "date" at position 126)
Unexpected token. (near "," at position 130)
Unexpected token. (near "published" at position 132)
Unexpected token. (near "," at position 141)
Unexpected token. (near "checked_out" at position 143)
Unexpected token. (near "," at position 154)
Unexpected token. (near "checked_out_time" at position 156)
Unexpected token. (near ")" at position 172)
SQL query: Documentation
INSERT `avsr3_phocaguestbook_items` (id, catid, parent_id, lft, level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time) SELECT id+1 AS id, 10013 AS catid, 1 AS parent_id, ordering AS lft, 1 AS level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time FROM `avsr3_pphocaguestbook_items`
MySQL said: Documentation
#1364 - Field 'path' doesn't have a default value
- Jan
- Phoca Hero
- Posts: 47887
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Cant Success While Transfreing Old DB Table
Hi, sorry, the copied sql didn't include the INTO, try to add it again, with the INTO:
Anyway, in the sql I copied here, was:
avsr3_pphocaguestbook_items, maybe this is wrong too as it should be: avsr3_phocaguestbook_items (in case your prefix is not: avsr3_p)
Code: Select all
INSERT INTO `avsr3_phocaguestbook_items` (id, catid, parent_id, lft, level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time) SELECT id+1 AS id, 10013 AS catid, 1 AS parent_id, ordering AS lft, 1 AS level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time FROM `avsr3_phocaguestbook_items`
avsr3_pphocaguestbook_items, maybe this is wrong too as it should be: avsr3_phocaguestbook_items (in case your prefix is not: avsr3_p)
If you find Phoca extensions useful, please support the project
- c a g a t a y
- Phoca Member
- Posts: 43
- Joined: 17 Aug 2009, 21:51
Re: Cant Success While Transfreing Old DB Table
hi Jan
avsr3_phocaguestbook_items --> this is Joomla 3.0 guestbook (no data)
avsr3_pphocaguestbook_items --> is old guestbook table (from Joomla 2.5) (with data)
inserted table into the Joomla 3.0 SQL schema
So, I have a SQL databese (at localhost/phpmyadmin) and 2 colums/tables (as seen below)
With these knowledges, what will i do?
to make clear;avsr3_pphocaguestbook_items, maybe this is wrong too as it should be: avsr3_phocaguestbook_items (in case your prefix is not: avsr3_p)
avsr3_phocaguestbook_items --> this is Joomla 3.0 guestbook (no data)
avsr3_pphocaguestbook_items --> is old guestbook table (from Joomla 2.5) (with data)
inserted table into the Joomla 3.0 SQL schema
So, I have a SQL databese (at localhost/phpmyadmin) and 2 colums/tables (as seen below)
With these knowledges, what will i do?