COMMUNITY FORUM

1064 Error on Transfer content joomla to k2

Start
Prev
1
Next
End

peyman
Topic Author
Offline
New Member

9 years 9 months ago #146009 by peyman

1064 Error on Transfer content joomla to k2 was created by peyman

Hi dears,

i instal joomla and nex k2 v 2.9 on my site, then i need to transfer joomla content to k2 content, but have a error with 1064 name,

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 ' 68534)' at line 1 SQL=INSERT INTO pwu4c_k2_tags_xref (`id`, `tagID`, `itemID`) VALUES (NULL, , 68534)

is thr a way for solv this problem??

Thanks

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

Franz Wohlkönig
Offline
Platinum Member

9 years 9 months ago - 9 years 9 months ago #146013 by Franz Wohlkönig

Replied by Franz Wohlkönig on topic 1064 Error on Transfer content joomla to k2

Hi,

please read www.joomlaworks.net/forum/k2-en/42249-1064-error-when-trying-to-create-new-k2-user-page-menu-item#145968
Regards

Last edit: 9 years 9 months ago by Franz Wohlkönig.

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

peyman
Topic Author
Offline
New Member

9 years 9 months ago - 9 years 9 months ago #146029 by peyman

Replied by peyman on topic 1064 Error on Transfer content joomla to k2

Thanks, I Read and do,

Thank you all for reporting this issue.
The issue has been resolved with this commit: github.com/joomlaworks/k2/commit/d3617d1c6c4602b1328bc5de82bb253e1002e5fa .

Apply the fix or install the development version from getk2.org/assets/get .

But When i Replace New Code form Github.com with my components/com_k2/models/itemlist.php, i have 1064 error again

next, when i download fixed version from getk2.org/assets/get, k2 ipmort just 538 content from Joomla and i see white page!!!!!!!! i have 3026 content

can i do?? is there a way??

Thanks!!!

Last edit: 9 years 9 months ago by peyman.

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

Krikor Boghossian
Offline
Platinum Member

9 years 9 months ago #146033 by Krikor Boghossian

Replied by Krikor Boghossian on topic 1064 Error on Transfer content joomla to k2

Enable error reporting so you can see the actual error.
This is most likely a memory limit related issue and you might need to increase your PHP memory limits.

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

peyman
Topic Author
Offline
New Member

9 years 9 months ago - 9 years 9 months ago #146118 by peyman

Replied by peyman on topic 1064 Error on Transfer content joomla to k2

I enable Error report and see:

Notice: Trying to get property of non-object in /home/perspol/public_html/v3/administrator/components/com_k2/models/items.php on line 1224

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 2134 bytes) in /home/perspol/public_html/v3/libraries/joomla/database/driver/mysqli.php on line 811

Last edit: 9 years 9 months ago by peyman.

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

peyman
Topic Author
Offline
New Member

9 years 9 months ago #146129 by peyman

Replied by peyman on topic 1064 Error on Transfer content joomla to k2

Now i solved this error by upgrade Host Memory Limit,

i have new problem with connection timeout

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

Lefteris
Offline
Platinum Member

9 years 9 months ago #146160 by Lefteris

Replied by Lefteris on topic 1064 Error on Transfer content joomla to k2

@peyman

Try the development version from getk2.org/assets/get .

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

Start
Prev
1
Next
End