| chill |
First Post Posted on: 01-12-13 05:49 PM |
| Problems with sql... |
|
| Dear Mewsoft:\
\
I get this error when I'm logged in as user and start to post ad in Classifiedawy. It occurs when I click the drop down menu for to Select Your Ad Type or the Select Your Region. \
\
SQL Error: You have an error in your SQL syntax near '=)' at line 1\
Query: \
SELECT Name FROM Ads_Categories_Name WHERE (Lang='English' AND Cat_ID=)\
Line 1320, File /home/httpd/vhosts/sellence.com/cgi-bin/classified/SQLlib.pm.\
\
I also noticed the Category button is blank and when I click it, a new window pops up telling me error 404.\
\
I didn't find any help on this in the forum, so this is why I am posting this.\
\
Charles |
|
|
|
|
|
| mewsoft |
Reply #: 1 Posted on: 01-13-13 06:26 AM |
| Re: Problems with sql... |
|
I regsitered on your site and tried to post an ad, your pst ad page is messed up, you need to restore the post ad template and language file. http://www.sellence.com/ |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
 |
| chill |
Reply #: 2 Posted on: 01-13-13 07:39 PM |
| No Problem, but have another problem. |
|
| Dear Mewsoft:\
\
I followed your instructions and the problem went away, but...\
\
Now, I have the same problem as post http://www.mewsoft.com/cgi-bin/forum/forum.cgi?action=ViewTopic&Topic=1852&Forum=3&Page=1&Period=0&Lang=English has. This was about the category list not showing up in the popup window. I followed what you told him to do, but to no avail. Basically, I uploaded all the files from the update except the data/templates/Default/Config.pm file, so I could retain the look and feel of the website. So, I don't know where my error is. The *.js in the html/classifieds/ are set to 755 (execution). Any help would be greatly appreciated.\
\
In addition, I can't upload a pic. The error reads: \
\
Can 't read source image file /home/httpd/vhosts/sellence.com/httpdocs/classifieds/upload/untitled.GIF: Inappropriate ioctl for device\
Line 911, File /home/httpd/vhosts/sellence.com/cgi-bin/classified/PostAdLib.pm \
\
Sincerely,\
Charles |
|
|
|
|
|
|
| mewsoft |
Reply #: 3 Posted on: 01-14-13 06:01 AM |
| Re: Problems with sql... |
|
The .js files should be uploaded in ascii mode. The Pic error means your GD modules is old and does not support the gif files. ask your hosting to update the GD module to the latest version or you wil haveto switch hosting if they refuse to update it. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
|
| chill |
Reply #: 4 Posted on: 01-14-13 06:25 PM |
| Tree categories working, but the dreaded sql error has occurred. |
|
| Dear Mewsoft:\
\
I got the categories tree to work. Thank you. The GD module should be updated by my host soon, too. But, now the post ad is not working. I'm getting the dreaded SQL Error: Unknown column 'Currency' in 'field list'Query: I noted the problems that others had, but I did upload all the update files correctly and set the permissions correctly and retained my frontpage look, so I don't know where the error is? I did previously do the updates regulary, but I must have made an error somewhere. But, I figured if I updated all the files in the update folder I recently downloaded, there wouldn't have been a problem... Any help on your part will be greatly appreciated as usual.\
\
Sincerely,\
Charles |
|
|
|
|
|
|
| mewsoft |
Reply #: 5 Posted on: 01-15-13 09:50 PM |
| Re: Problems with sql... |
|
| To aviod all the mess done, do fresh install under another folder and use the same mysql database to keep you database, then transfer your customizations to the new install. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
|
| chill |
Reply #: 6 Posted on: 01-18-13 06:31 PM |
| Some progress is being made. |
|
| Dear Mewsoft:\
\
I did as you suggested and things seem to be working ok. I do have two questions that I can't resolve though. \
\
How do I change the categories so that they are not in one long row. I'm using my customized front page and everything is ok except for the categories and its subfolder. I like the old front page format, so the categories will be in the same place as old setup you had with the featured and newest below.\
\
I cannot get the visualhtmleditor to work in the viewad page. I followed what you told others about removing the line and changing the "" "1", so it will always be available, but this doesn't work. I noticed it doesn't work in your demo either.\
\
As usual, any help will be greatly appreciated.\
\
Sincerely,\
Charles |
|
|
|
|
|
|
| chill |
Reply #: 7 Posted on: 01-19-13 03:01 PM |
| About the home page columns |
|
| Dear Mewsoft,\
\
I found out how to change the home page column number. But, I still need help on the visualhtmleditor.\
\
Charles |
|
|
|
|
|
| mewsoft |
Reply #: 8 Posted on: 01-19-13 07:26 PM |
| Re: Problems with sql... |
|
|
|
|
| chill |
Reply #: 9 Posted on: 01-20-13 01:35 PM |
| About the zip file |
|
| Dear Mewsoft,\
\
I downloaded the file, but I'm getting an error.\
\
Error#: 25115\
Error: Bad offset to local header.\
\
I believe the zip file is corrupted.\
\
Sincerely,\
Charles |
|
|
|
|
|
| mewsoft |
Reply #: 10 Posted on: 01-20-13 01:44 PM |
| Re: Problems with sql... |
|
|
|
|
| chill |
Reply #: 11 Posted on: 01-20-13 02:26 PM |
| Zip file... |
|
| Dear Mewsoft,\
\
The update is functioning just fine! Thank you. If you don't mind, I would like to suggest something. Is it possible to put in our my accounts the date(s) for paying the renewal licenses for the products we paid for and is it possible for all the updates for all the products we paid for to be in our my accounts. For example, in my account the update for classifiedawy is the only product there, but I have purchased backupawy and validawy. I hope this makes sense...\
\
Sincerely,\
Charles |
|
|
|
|
|
|
| chill |
Reply #: 12 Posted on: 01-23-13 07:22 PM |
| About the image upload. |
|
| Dear Mewsoft,\
\
My web hoster updated the GD Module, but it still doesn't work. Here is the information.\
\
GD Module Version 2.35. Required 2.19 at least\
\
GIF Test \
----------------\
File: /var/www/vhosts/sellence.com/cgi-bin/test.gif \
\
Trying to read the Gif graphics file with GD ...\
I can read Gif file\
\
Trying to create new Gif image \
I can create Gif images \
\
Trying to resize Gif image \
Done resizing.\
\
Trying to create Gif output file \
I can write output JPG images \
\
\
JPG Test \
----------------\
File: /var/www/vhosts/sellence.com/cgi-bin/test.jpg \
\
Trying to read the Jpeg graphics file with GD ...\
I can read Jpeg file\
\
Trying to create new JPG image \
I can create JPG images \
\
Trying to resize JPG image \
Done resizing. \
\
Trying to create JPG output file \
I can write output JPG images \
\
\
PNG Test \
----------------\
File: /var/www/vhosts/sellence.com/cgi-bin/test.jpg \
\
Trying to read the Png graphics file with GD ...\
I can read Png file\
\
Trying to create new Png image \
I can create Png images \
\
Trying to resize Png image \
Done resizing. \
\
Trying to create Png output file \
I can write output Png images \
\
\
Done... \
\
Here is the error:\
\
Can 't read source image file /home/httpd/vhosts/sellence.com/httpdocs/class/upload/untitled.GIF: Inappropriate ioctl for device\
Line 842, File /home/httpd/vhosts/sellence.com/cgi-bin/class/PostAdLib.pm \
\
Sincerely,\
Charles |
|
|
|
|
|
|
| mewsoft |
Reply #: 13 Posted on: 01-23-13 08:17 PM |
| Re: Problems with sql... |
|
|
|
|
|