Copy all data to new site

  • LarryG
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 months ago #5620 by LarryG
Replied by LarryG on topic Copy all data to new site
Well, it sort of worked. The maps and paths appear to have come over just fine, but placemarks and placemark groups give an error when clicked on in the admin console.

Any chance this means something to you?
Unknown column 'h.access' in 'on clause' SQL=SELECT COUNT(*) FROM database_zhgooglemaps_markers as h LEFT JOIN database_categories as c on h.catid=c.id LEFT JOIN database_zhgooglemaps_maps as m on h.mapid=m.id LEFT JOIN database_zhgooglemaps_markergroups as g on h.markergroup=g.id LEFT JOIN database_users as usr on h.createdbyuser=usr.id LEFT JOIN database_viewlevels as ag ON ag.id = h.access WHERE (h.published IN (0, 1))
Unknown column 'h.ordering' in 'field list' SQL=SELECT h.id,h.title,h.mapid,h.published,h.publish_up,h.publish_down,h.catid,h.icontype,h.ordering,h.rating_value,h.createdbyuser,h.access,c.title as category,m.title as mapname,g.title as markergroupname, usr.username, usr.name fullusername,ag.title as access_level FROM database_zhgooglemaps_markers as h LEFT JOIN database_categories as c on h.catid=c.id LEFT JOIN database_zhgooglemaps_maps as m on h.mapid=m.id LEFT JOIN database_zhgooglemaps_markergroups as g on h.markergroup=g.id LEFT JOIN database_users as usr on h.createdbyuser=usr.id LEFT JOIN database_viewlevels as ag ON ag.id = h.access WHERE (h.published IN (0, 1)) ORDER BY h.title asc LIMIT 0, 20
Unknown column 'h.access' in 'on clause' SQL=SELECT COUNT(*) FROM database_zhgooglemaps_markers as h LEFT JOIN database_categories as c on h.catid=c.id LEFT JOIN database_zhgooglemaps_maps as m on h.mapid=m.id LEFT JOIN database_zhgooglemaps_markergroups as g on h.markergroup=g.id LEFT JOIN database_users as usr on h.createdbyuser=usr.id LEFT JOIN database_viewlevels as ag ON ag.id = h.access WHERE (h.published IN (0, 1))

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #5622 by Dima
Replied by Dima on topic Copy all data to new site
You have to have on both sites the same versions of component, because when component installing it can modify database (create or alter tables)

Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

  • LarryG
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 months ago #5623 by LarryG
Replied by LarryG on topic Copy all data to new site
That makes sense. I didn't think about it, but the old site has been up for a while so it probably does have an older version.

Can I update the old site to a new version (so I can export again) or would that break things on the old site?

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #5624 by Dima
Replied by Dima on topic Copy all data to new site
Yes.
You can upgrade old site, or both to last version.

Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

  • LarryG
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 months ago #5625 by LarryG
Replied by LarryG on topic Copy all data to new site
That worked - upgraded the old one to the new version, exported again, imported, and everything but Categories is there.

Thanks again!

P.S. Out of curiosity, why doesn't the Categories list export?

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #5628 by Dima
Replied by Dima on topic Copy all data to new site
Categories, it is joomla entity, ie it's table
And it saves just a little bit in different way. You can export-import all categories, or if have little knowlege of SQL - export only records which you want.

Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

Time to create page: 0.116 seconds

Donate


Go to top