Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 07:06 pm EST

Geeklog Forums

SQL ErrorTables?


Status: offline

MoJoPokeyBlue

Forum User
Newbie
Registered: 10/14/03
Posts: 3
I added a new File (gl_librariantypes) to my geeklog database, and am using the COM_optionList function in the common library. However, it would appear that Geeklog isn't recognizing my new file...here's what's in the error.log:
"...SELECT lc_value,lc_descr FROM ORDER BY lc_value..."

As you will notice, there's no Table referenced. Is there a Table of allowable tables somewhere?...If so, where?

Any help is greatly appreciated !!

MoJo
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
The names of the tables that Geeklog uses are in lib-database.php.

You can add your own table name to the global $_TABLES array, but you shouldn't modify lib-database.php. Instead, put this somewhere in one of your own .php files.

bye, Dirk
 Quote

Status: offline

MoJoPokeyBlue

Forum User
Newbie
Registered: 10/14/03
Posts: 3
Uh...ok. I'm an idiot.

I didn't even think to look in the /system directory!

I made the change and everything is working fine. Thanks for the prompt reply!!!

MoJo
 Quote

All times are EST. The time is now 07:06 pm.

  • 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