1
mattm
small migration issue with xoops_tplsource
  • 2005/2/5 13:31

  • mattm

  • Just popping in

  • Posts: 28

  • Since: 2004/3/8 2


Has anyone had a problem, during migration, with uploading the contents of "xoops_tplsource"?

I'm finding that I'm getting syntax errors when I try to upload using phpmyadmin. It comes up with

Quote:

#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 'visit.php?cid=<{$link.cid}>&' at line 1


Immediately prior to the 'visit.php...' part, is a phpsession ID in " quotes (not sure if that is any use to know but thought I'd mention it).

Can anyone help?

2
m0nty
Re: small migration issue with xoops_tplsource
  • 2005/2/5 13:38

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


i think it's to do with the method u exported the db..

if you used quotes for fieldnames and the text contains quotes aswell MySQL might think that you're closing a table/field name and starting another..

so in your case > 'visit.php?cid=<{$link.cid}>&' maybe confusing it..

it's hard to say without seeing some of the query.. some manual editing of the .sql or csv file might be needed

3
mattm
Re: small migration issue with xoops_tplsource
  • 2005/2/5 13:47

  • mattm

  • Just popping in

  • Posts: 28

  • Since: 2004/3/8 2


Thanks for the response. I'm using phpMyAdmin with the options set to

add drop table - selected
enclose table & field names with backquotes - selected

complete inserts - selected

here is the sql output with session ID edited - (don't know if that is necessary or not but seemed sensible!)
Quote:

ERROR: Unknown Punctuation String @ 363
STR: =<
SQL: INSERT INTO xoops_tplsource VALUES (36, '<table class="outer" width=\'100%\' cellspacing=\'0\'>\n <tr>\n <td class="head" colspan=\'2\' align=\'left\' height="18"><{$lang_category}> <{$link.category}></td>\n </tr>\n <tr>\n <td class="even" width=\'60%\' align=\'left\' valign="bottom"><a href="\?PHPSESSID=*snip!*"'visit.php?cid=<{$link.cid}>&lid=<{$link.id}>\'


It goes on from there but that covers the area it appears to be upset about. Don't really know enough to be able to troubleshoot the syntax.

4
mattm
Re: small migration issue with xoops_tplsource
  • 2005/2/5 14:02

  • mattm

  • Just popping in

  • Posts: 28

  • Since: 2004/3/8 2


OK - just re-read your post. Unselecting "Enclose table and field names with backquotes" has fixed the problem.

Thanks!

5
highlander
Re: small migration issue with xoops_tplsource
  • 2005/2/5 14:04

  • highlander

  • Not too shy to talk

  • Posts: 151

  • Since: 2004/12/5


Try changing :
<a href="?PHPSESSID=*snip!*"'visit.php?cid=<{$link.cid}>&lid=<{$link.id}>'


to :
<a href="?PHPSESSID=*snip!*"'visit.php?cid=<{$link.cid}>&lid=<{$link.id}>'


Highlander

edit :- too late !

6
mattm
Re: small migration issue with xoops_tplsource
  • 2005/2/5 14:09

  • mattm

  • Just popping in

  • Posts: 28

  • Since: 2004/3/8 2


@highlander

Thanks for looking - looks like it just required a little tinkering with phpmyadmin.

At least the question is now answered for anyone else that has the problem!

Login

Who's Online

151 user(s) are online (97 user(s) are browsing Support Forums)


Members: 0


Guests: 151


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits