strange error

jjj0923 · February 13th, 2011, 07:54 AM

this just started happening on our site a few days ago.

any ideas why? - the product has been running fine for a few years.

I am trying to place a new ad in photopost classifieds.
-----------------------------------------------------

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: uploadproduct

Query: INSERT INTO products (id,user,userid,cat,date,title,description,keywords,bigimage,bigimage2,bigimage3,approved,watermarked,ipaddress) values(NULL,'administrator', 1, 3, , 'test', 'this is a test', '', '', '', '', 0, '', '24.154.88.237')

Result: 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 ' 'test', 'this is a test', '', '', '', '', 0, '', '24.154.88.237')' at line 2

Database handle: Resource id #29

Powered by: PhotoPost Classifieds 2.42 vB3 Enhanced
Copyright 2005 All Enthusiast, Inc.

jjj0923 · February 13th, 2011, 07:54 AM

ps: it's not a lack of disk space....

Chuck S · February 13th, 2011, 09:31 AM

I will move this post to the proper support forum however to have a support technician respond to your issue you will need proper support access. One owned license grants you the right to run one software installation on one domain for an unlimited time, and purchasing an owned license gives you access to our members download area and support for one year. Your support and download access has expired which means you need to renew members access to receive product support.

jjj0923 · February 13th, 2011, 10:37 AM

not true - we recently purchased an upgrade license... I just have to find the paperwork.

Chuck S · February 13th, 2011, 10:52 AM

If thats the case then please read the announcement at the top of the support forums on how to become verified. We have lots of customers and your forum account is linked to an email that is not associated with a license that has current members access. This is how support knows you are able to receive product support by that tag.

Secondly if your using such an old version you would most likely want to upgrade.

jjj0923 · February 18th, 2011, 10:22 AM

my license should be linked to this login now since I updated my email address. can you help me out now?

license 30862 - thanks

Chuck S · February 18th, 2011, 10:38 AM

Have you updated your code to see if it resolves your issue?

jjj0923 · February 18th, 2011, 10:42 AM

"as in upgrading to the latest version" ??? Is that what you mean?

I'm a little risk adverse in terms of upgrading code at this time, but will if your insist. I just don't understand why the problem would suddenly appear without any changes to the code and against a database that has proven flawless for years...

ps: my preference is typically to solve a problem by understanding and fixing it as opposed to throwing a new version at it in the hopes it will go away. I think it's database related because clicking on any of the ads after you see the classifieds landing page yields the following error:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: showproduct

Query: REPLACE INTO laston VALUES(6,1,)

Result: 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

Database handle: Resource id #30

=========================

and I'm afraid upgrading will just yield the same results.

Chuck S · February 18th, 2011, 11:13 AM

I would suggest you try upgrading sure

your using an extremely old version

Basically your issue is your time is EMPTY

I would think using the latest software not old software which might not be compatible with newer versions of php or other changes that have happened on your site would help you.

jjj0923 · February 18th, 2011, 11:30 AM

upgrade stopped dead in it's track at the move data...

jjj0923 · February 18th, 2011, 11:31 AM

now what?

there was no browser activity at all in terms of the browser waiting or doing something.

this time I'll tail the php error log file to see what's going on there....after I untar the backup and restore the database then copy all of the new code back into the directory .... this is why I f'in hate upgrades....another 20 minutes of work to get back to the spot where I left off...

just to watch it fail again... arrggh!

Chuck S · February 18th, 2011, 11:50 AM

You can not run old code on newer php versions which is why you need to upgrade.

I have removed our code from your post so please refrain from publicly posting code opening on the site thanks.

Now please explain what you mean by it stops dead in its tracks. The upgrade can take awhile. The step you are referring to also can only be ran once so do not run step3 of that upgrade more than once. The move data is step 2 that can be done more than once.

I would suspect maybe a php timeout. The upgrade script sets memory limit to 60M in php and timeout to 0.

Do you have a link to your servers phpinfo so I can make any comments necessary to assist?

The upgrade you are referring to has been around for years. I would definately need info from server logs to diagnose that issue. Basically the upgrade there moves files to the new format and then step 3 renames the filenames which is why you can not run that step more than once.

jjj0923 · February 18th, 2011, 12:05 PM

sorry chuck the phpinfo is protected so that prying eyes can't see it.

the link at the bottom of the screen to move the data did basically nothing at all. no browser activity...nothing what so ever - it's almost as if it was a dead link.

I do have one question. aside from just running upgrade.php do I need to modify any of the uploaded config files before running the upgrade step?

I will wait for your answer before I proceed.

Chuck S · February 18th, 2011, 12:11 PM

You do not need to modify anything you simply need to ensure that both config-inc.php and config-intc.php exist on the server

You can send site info to the contact us link in the header I really without proper information can just guess.

jjj0923 · February 18th, 2011, 12:47 PM

I'm totally stuck and about to can everything. I been through numerous upgrades and have never had to so little to go on in terms of lack of any types of error messages.

I get this over and over in my phperrlog file:

[18-Feb-2011 12:34:55] PHP Fatal error: Call to undefined function get_regcode() in /usr/local/websites/www.mysite.com/mysite/classifieds/pp-inc.php on line 2764

and when I click on the link to do the directories I got taken to a browser window that is blank and nothing is taking place.

this is nuts....

jjj0923 · February 18th, 2011, 12:49 PM

Quote:

Originally Posted by Chuck S

You can send site info to the contact us link in the header I really without proper information can just guess.

I would do this but my apache config file only permit certain ip's to get to the directory to where that is located.

if you email me your ip address I'll open out firewall to give you ssh access to the server.

Jeff

jjj0923 · February 18th, 2011, 01:08 PM

perhaps there was nothing to convert so I proceeded all the way to the end of the conversion and now I get:

[18-Feb-2011 12:58:49] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required './forums/vb3.php' (include_path='.:/usr/share/pear:/usr/share/php') in /usr/local/websites/www.mysite.com/mysite/classifieds/pp-inc.php on line 4607

I know my path names are setup correctly in the config files because they have not changed.

I'll turn off vb3 interface and see what happens

jjj0923 · February 18th, 2011, 01:12 PM

no joy - the program starts without vb3 interface turned on, but no pictures or thumbnails display.

I am out of ideas and dead in the water without help from you guys.

sorry if I sound angry and frustrated - it's because I am...I was hoping for some error messages so that I did not have to ask for help here.

Chuck - I have restored everything to it's 2.42 state and then uploaded Version 4, but have not started the upgrade.

If you email me your ip address, I'll open our firewall to give you ssh access and let you know the path to the program and location of phperror and apache log files so that you can try the upgrade for yourself.

thanks in advance...

Chuck S · February 18th, 2011, 02:06 PM

You can email any site data to the contact us link in the header

I am not turning over my personal ip to anyone sorry. You can send at least url and admin login if you want me to pook around that does not require file access.

Your not going to show images etc if you have not upgraded properly but at least your classifieds admin panel is going to show me your paths phpinfo etc and if you have permissions correct on our files I should be able to set proper paths in there etc

jjj0923 · February 18th, 2011, 02:34 PM

check - could the root of the problem be this error which I am getting over and over?

Call to undefined function get_regcode() in /usr/local/websites/www.mysite.com/mysite/classifieds/pp-inc.php on line 2764

ps: I would give you access to the admin panel but it won't even come up for me because of the get_regcode error

jeff