Problem with MySQL

[where2nite]

Hi,

Forgive me for I very little knowledge of web design and have come here as I needed somewhere to host my polls because I use many polls for my site. I acquired an item called Easy Poll Create

http://www.codedworld.com/download/easy-poll-creator/58841.html

and followed the instructions on how to install it to the letter. I linked my database and all that.

Now, when I go to save any polls I create I get the following message:

Could not successfully run query (SELECT * FROM poll WHERE Poll_ID = ) from DB: 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 '' at line 1

and when I go to preview any polls I get this message:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@where2nite.x10hosting.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8b mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at where2nite.x10hosting.com Port 80 I know I'm providing very little information for anyone to be able to figure out what exactly is wrong, but I'd really appreciate any help on the issue. Thank you,Rory.

 

[Russ]

Login to cPanel, go to the logs section, click on Server Error Log, and paste the output of the top 5 lines here

 

[where2nite]

Thanks for the response.

Here's the log:

[Mon Feb 25 16:06:38 2008] [error] [client 86.42.96.174] File does not exist: /home/dinnigan/public_html/500.shtml
[Mon Feb 25 16:06:38 2008] [error] [client 86.42.96.174] SoftException in Application.cpp:238: File "/home/dinnigan/public_html/Polls/Code/pollPreviewer.php" is writeable by group


I don't know if that will help. There doesn't appear to me much information.

 

[Christopher]

The file permissions are higher than 755. Set them to 755.

 

[where2nite]

Thank you. I'll try that now, although in the guide for installation it says:

Change the permission of the following to '777'

* Folder temp
* File 'config.php'


In fact, here's the guide that I followed to the letter:

How to install

The installation is very easy. Follow the step-by-step process:

A) Upload files to your server

* Download EasyPoll.zip to your local machine.
* Unzip the file
* Create a folder within public_html on your server.
* Upload all the folders and files within EasyPoll to this new folder
* Change the permission of the following to '777'
o Folder temp
o File 'config.php'

* Note: Easy Poll has been encoded with the ionCube PHP Encoder and requires the free ionCube PHP Loader to be installed.

B) Create a database and user in MySQL Database

* Open your cPanel (Control Panel) to access MySQL Database
* Create a database
* Create a User by providing username and password
* Link the database with the user

C) Install the script

* Now open following link in your browser:
o http://yourdomainname.com/foldername/install.php
where:
yourdomainname.com : your domain name
foldername : the name of the newly created folder, where you would have uploaded all the files and folder.

* Provide all the inputs as specified below:
o Database Server : <your database server> e.g. localhost
o Username : <username created in MySQL Database>
o Password : <Password for the above mentioned username>
o Database : <database created in MySQL Database>
o Tables Prefix: Prefix to be used for script tables in the database.
o Admin Username: Username to login for administration panel of the system.
o Admin Password: Password to login for administration panel of the system.

* Click on 'Install'

* After you finish the installation process, remove install folder from the server, to avoid the problems that may caused by tampering the script.
Edit:
I tried it with a clean run and it won't install without changing the temp folder and config.php to 777.

I noticed it said PollPreviewer is writeable by group and I took away that permission and I can now at least preview the polls. I still can't save them however.

I noticed soemthing with my last remaining error message below:

[Mon Feb 25 19:51:10 2008] [error] [client 86.42.96.174] File does not exist: /home/dinnigan/public_html/500.shtml

There it says .shtml. Is that a mistake by the people who coded My Poll Creator? Should that be html and not shtml? Again... I've no knowledge, so I'm just asking. If that is the problem how would I go about fixing that?

 

[Russ]

Our system does not currently allow it, 755 SHOULD work fine, I just installed a script a few days ago with the same requirement, 755 worked fine

 

[easykey]

The following query is wrong:

(SELECT * FROM poll WHERE Poll_ID = )

Its saying get everything from the table "poll" where Poll_ID is a certain value. If you don't put a value in you will get a syntax error. To be honest a well written piece of code that is available for sale would spot that there was no ID and provide a helpful error message rather than using raw PHP/MySQL error trapping.