Welcome to Geeklog Sunday, January 23 2022 @ 10:56 am EST

Geeklog Forums

An SQL error has occured. Please see error.log for details.


Status: offline

doopisdotnet

Forum User
Chatty
Registered: 31/01/03
Posts: 38
my error log reads:

PHP Formatted Code
Mon Jan 17 09:51:22 2005 - Attempting to install the Venue Page Plugin
Mon Jan 17 09:51:22 2005 - Attempting to create table venue for Venue Page plugin
Mon Jan 17 09:51:22 2005 - ...success
Mon Jan 17 09:51:22 2005 - Attempting to create Venue Page admin group
Mon Jan 17 09:51:22 2005 - ...success
Mon Jan 17 09:51:22 2005 - Attempting to add venue.edit feature
Mon Jan 17 09:51:22 2005 - ...success
Mon Jan 17 09:51:22 2005 - Attempting to add venue.delete feature
Mon Jan 17 09:51:22 2005 - ...success
Mon Jan 17 09:51:22 2005 - Attempting to add venue.PHP feature
Mon Jan 17 09:51:22 2005 - ...success
Mon Jan 17 09:51:22 2005 - Attempting to give Venue Page Admin group access to venue.edit feature
Mon Jan 17 09:51:22 2005 - ...success
Mon Jan 17 09:51:22 2005 - Attempting to give Venue Page Admin group access to venue.delete feature
Mon Jan 17 09:51:22 2005 - ...success
Mon Jan 17 09:51:22 2005 - Attempting to give Venue Page Admin group access to venue.PHP feature
Mon Jan 17 09:51:22 2005 - ...success
Mon Jan 17 09:51:22 2005 - Attempting to give all users in Root group access Venue Page admin group
Mon Jan 17 09:51:22 2005 - ...success
Mon Jan 17 09:51:22 2005 - Registering Venue Page plugin with Geeklog
Mon Jan 17 09:51:22 2005 - ...success
Mon Jan 17 09:51:22 2005 - Succesfully installed the Venue Page Plugin!
Mon Jan 17 09:51:23 2005 - 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 'WHERE vp_onmenu = 1 ORDER BY vp_label' at line 1. SQL in question: SELECT vp_id, vp_label, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon FROM  WHERE vp_onmenu = 1 ORDER BY vp_label
 


anyone got any ideas?

( i got a successfull installation notice, then within 1/2 a second got a message that my site was down!) Banging your head
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 22/03/04
Posts: 1512
you can start by disabling that plugin.. do it from the database. then you site should come back.

as for the error, the select statement in question is missing the FROM table. you'll have to seek that out in your plugin code.
 Quote

Status: offline

doopisdotnet

Forum User
Chatty
Registered: 31/01/03
Posts: 38
Quote by machinari: you can start by disabling that plugin.. do it from the database. then you site should come back.

as for the error, the select statement in question is missing the FROM table. you'll have to seek that out in your plugin code.


i appreciate the response

i tried to clone staticpages into 'venue pages' - but all i did was copy all the directories in the correct places, then i replaced

sp_ with vp_
staticpage with venuepage
Static Page with Venue Page
static with venue
then uploaded all the directories in the appropriate places, ran the install script from the admin panel, got the confirmation that it was successfull but 1 second later site was down due to the syntax error

i had to use a gl backup from just before i uploaded those files

anyone interested in makeing a clone of static pages for me, ill pay you

i need one named 'Venue Pages' with the directory named 'venue' and another one named 'Mailer Pages' with the directory named emailer'

-Christian
 Quote

All times are EST. The time is now 10:56 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content