Welcome to Geeklog, Anonymous Friday, November 22 2024 @ 04:27 pm EST
Geeklog Forums
SQL error has occured
Marcus
after the scriped hast installed the database, i want to start geeklog index.php. But following happened in the browser window:
The error.log-file says:
SQL in question: SELECT DISTINCT ft_name FROM gl_access,gl_features
WHERE ft_id = acc_ft_id AND acc_grp_id IN ()
Than I find the code in lib-security.php:
{$_TABLES["access"]},{$_TABLES ["features"]} "
. "WHERE ft_id = acc_ft_id AND acc_grp_id IN ($glist)");
It seems that $glist has some problems because the error.log says null ....
Please help - Thank you!
Dirk
Since this appears to be a fresh install, try dropping the tables and running the install script again. Pay close attention to see if any error messages may flash up during the install.
bye, Dirk
ccado
I have exactly the same problem, even if i re-run install of the database.
At the end of step 2 of 2 of the install, appear a blank page rather than a success message. Then the datbase is empty !
Cara
ERROR 1064 at line 1025: 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 'table `gl_storysubmission` Jan 08, 2004 at 01:00 PM `gl_storysu
Greek to me. All I did was fill in the directory name I wanted it to go to and a user name/password to install it automatically.
I am really new at this and I don't want to just give up before I even begin but this is making me crazy. I thought it was maybe just a glitch of my computer so I deleted and tried again with the same result; deleted, rebooted, same...
If someone could point me in the right direction for either some help or what I can do to fix this, it would be appreciated!
Thanks in advance!
Ken Jones
I use a custom installer script on my sites (I had to beg my hosting provider for SSH access), but curiosity led me to take the Fantastico installer script for a spin anyway and see what it could do.
I'm glad to say it went well. After entering some basic configuration info (site name/slogan, (sub)domain and path, and admin username/pass) I was presented with a fresh installation of Geeklog 1.3.9; unlike the normal geeklog install process, no 'Moderator' account was created, just the one admin account which I had provided the name and password for; the install directory had been removed, so the site was left in a pretty secure configuration.
That said, here's some issues I have with how it was installed:
- All files were installed in the 'web root' folder, in other words, all the files outside of 'public_html' were moved inside it. This means that by browsing to http://newgeeklogsite.com/system I could see a list of all the files inside it, and I could read all the non-php ones; I could also attempt to execute PHP scripts which weren't intended to stand alone, such as config.php and the Pear libraries. Although I didn't find any ways to cause real trouble, this is pretty bad and could help malicious users find ways to harm your site.
- No options were provided to help configure the 'emailgeeklogstories' cron job, even though my provider supports cron jobs.
- None of the optional image libraries were configured, even though my service provider has both NetPBM and ImageMagick installed.
Noah
Ultimately, my problem was my database user account didn't have enough privileges to the geeklog database for a successful installation. Once I had the privileges set right, I dropped the geeklog database with the empty tables and re-ran the installer and all was well.
- 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