| |
|
Who's Online |
|
We have 34 guests online |
|
Newsletter |
|
Subscribe to our newsletter.
|
|
Donate |
If you use and like my scripts, and would like further developments, please consider donating a few bucks.
|
|
Re:Viewing entries in admin backend gives error: 1064 (1 viewing) (1) Guest
Favoured: 0
|
|
|
TOPIC: Re:Viewing entries in admin backend gives error: 1064
|
arkadas (User)
Fresh Boarder
Posts: 1
|
|
Viewing entries in admin backend gives error: 1064 1 Year, 1 Month ago
|
Karma: 0
|
|
Jambook: Version: 1.0 RC1
Database Version: 5.0.67-community-nt
PHP Version: 5.2.5
Joomla! Version: Joomla! 1.0.15
Browser: Mozilla firefox 3.0.x
When going to guestbook entries in the backend, i'll get the firsttime a nice overview, then i select the next page for the next 20 entries in the guestbook and i get the following error:
SELECT c.*, u.name AS editor
FROM jos_jx_jambook AS c
LEFT JOIN jos_users AS u ON u.id = c.checked_out
WHERE c.state >= 0
ORDER BY created DESC
LIMIT , 10
DB function failed with error number 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 ' 10' at line 6 SQL=SELECT c.*, u.name AS editor FROM jos_jx_jambook AS c LEFT JOIN jos_users AS u ON u.id = c.checked_out WHERE c.state >= 0 ORDER BY created DESC LIMIT , 10
The guesbook look further fully functional on the backend and frontend of joomla
regards,
Arkadas
|
|
|
|
|
|
|
Last Edit: 2009/02/05 16:49 By arkadas.
|
|
|
The administrator has disabled public write access.
|
mlevack (User)
Fresh Boarder
Posts: 2
|
|
Re:Viewing entries in admin backend gives error: 1064 10 Months, 3 Weeks ago
|
Karma: 0
|
|
I am getting the same error - did you ever resolve this issue?
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
mlevack (User)
Fresh Boarder
Posts: 2
|
|
Re:Viewing entries in admin backend gives error: 1064 10 Months, 3 Weeks ago
|
Karma: 0
|
|
Well - I loggd out, then logged back in and that seemed to fix the issue.
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
aeisan (User)
Fresh Boarder
Posts: 2
|
|
Re:Viewing entries in admin backend gives error: 1064 9 Months, 1 Week ago
|
Karma: 0
|
|
Is there a fix for this?
|
|
|
|
|
|
|
Last Edit: 2009/06/12 16:03 By aeisan.
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Viewing entries in admin backend gives error: 1064 5 Months ago
|
Karma: 0
|
|
I have this error too. Olle, Do you know why? you have any fix for this.
Thanks a lot!
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Viewing entries in admin backend gives error: 1064 5 Months ago
|
Karma: 0
|
|
I figured out the solution: just delete the item being edited (checked out) or check in the item and the error's gone.
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
|
|
|
|
|
|
|
Support Forum 
