LATH

Now, I'm happy!!! The TCH Special Forces Team lead by Balakrishnan U solved the problem!

I'll leave it alone for a while...

Thank you but Magento installed from CPanel is failing with 5.5 and 5.4. I have uninstalled and reinstalled using CPanel just to see if any of the recent changes had any affect ... nope. The system log is currently recording the "mysql_old_password".

BTW...now some cron jobs aren't working since the last "Pdo_Mysql" change. These aren't very important to me right now so I just turned them off. When they are I'll recreate to see if that resolves the issue. Here's an example error message...this one being for a cron associated with Magento which I'm likely to uninstall: "Cannot load the ionCube PHP Loader - it was built with configuration API220090626,NTS, whereas running engine is API220100525,NTS" Yea, I'm a little disappointed in this whole event and not asking for anything except the previous questions...

I recently got the urge to play around with E-Commerce software as another place to sell things I make other than Ebay which is fine. I went to Softaculous App installer and installed Magento particularly attracted because there was some association with Ebay. Magento did not work "out of the box". After spending some time on my own I opened case [#LVF-285-12399]. The guys tried several things from rolling PHP back to version 5.3 and then "Pdo_Mysql extension to my account". It seemed too much trial and error was going on so I'm no longer asking for help on the ticket. Questions: 1) Does anyone know if the Magento version 1.9.1.0 support PHP 5.4? According to the Magento site: "Supports PHP 5.4. For more information, see the PHP changelog". But this is my result when testing: 5.5 - Magento fails 5.4 - Magento fails 5.3 - Magento success 2) Any recommendations on E-Commerce software? (For this initial trial I want free community software. Not ready to sink more $$$ into my hobby.)

They got it all working...thanks for the help!

No problem. I only noticed this topic for the first time while looking for information about SOAP. Take the time and do it right. Believe me I understand.

Will do...thanks!

I started looking today at the options available for creating a SOAP web service with PHP exposing some MySQL data. Has anyone worked with this in our environment? I did a phpinfo() and...no SOAP extension installed... I found the PEAR package for SOAP 0.12.0 and installed it. But, it didn't work out out of the gate... I'm wondering if anyone has had success before I start digging into it too much.

Is server92 locked in the "stoneage". I see this discussion, but notice that server92 is still Apache version 1.3.39 (Unix) .

I was looking around for tips on timezones for another reason...and it struck me to comment on this if this issue ever comes to someones mind again... Maybe it would be possible to collect the remote browser's timestamp and put it into a cookie...then read the cookie on the server.

Thanks for the reply. That is what I was thinking, but I was alarmed at the prospects of a lot of code changes (someone else's code to boot). Oh well...thanks for the confirming opinion.

I'm working with a script of a 3rd party product that has no support and have run into an issue with MySql connections...they hit the max intermittently. This is the typical error message: PHP Warning: mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: User xxxxx has already more than 'max_user_connections' active connections in /home/xxxxx/public_html/auction/includes/config.inc.php on line 113 According to the online docs mysql_pconnect() "Establishes a persistent connection to a MySQL server". I've only used mysql_connect(). The docs also say "mysql_close() will not close links established by mysql_pconnect()". The docs also give this warning: "Using persistent connections can require a bit of tuning of your Apache and MySQL configurations to ensure that you do not exceed the number of connections allowed by MySQL." Has anyone had experience with this issue?

Well, I got the bidding to work ...more date issues. The registration confirmation email is working too...strange issue...won't even go into it. I just want a cheap site to try to auction off 100s of old early 1900 postcards and other things...drop the bait and see if anyone bites...EBay is too expensive for this kind of thing.

This is my last word on this subject of PHPAuction provided by Fantastico. Don't use it! After the date parsing fixes I found a few more things I'm still working on: 1) Email confirmation when a user registers is not working...no email is sent. (However, an email confirmation is sent when a user submits an item to be sold...so, there's an opportunity for comparison) 2) SQL problem is encountered when a bid is entered...it is probably related to the timestamp: Database access error. Please contact the site administrator. update PHPAUCTION_auctions set current_bid=10000,starts=2007-02-22 23:25:28,ends=2007-02-25 23:25:28 where id="3c5d32571e80ee9d33e3d64f918c0755" 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 '23:25:28,ends=2007-02-25 23:25:28 where id="3c5d32571e80ee9d33e3d64f918c0755"' at line 1 Too many problems with this product ...but, I'm a little determined now to get it working.

A couple of files have code like this: $ends = substr($item[ends],6,2)."/".substr($item[ends],4,2)."/".substr($item[ends],0,4); That I changed to this: $tmp_ends = $item[ends]; //added $tmp_ends = ereg_replace("/|-|:|\ |\.|,","",$tmp_ends); //added $ends = substr($tmp_ends,4,2)."/".substr($tmp_ends,6,2)."/".substr($tmp_ends,0,4); //added The dates seem to work now...I think I found all of the spots that needed a fix.

It appears that the PHPAuction code has a problem with our version of MySQL...??? In any case these are my observations while looking at the listauctions.php file... The code retrieves the date in typical fashion: $tmp_date = mysql_result($result,$i,"starts"); The value of $tmp_date in my example is: 2007-02-21 22:45:33 Then the code attempts to parse out the year, month and day parts: $day = substr($tmp_date,6,2); $month = substr($tmp_date,4,2); $year = substr($tmp_date,0,4); $date = "$month/$day/$year"; The only problem with this that is it is picking up the dashes. The result is that the value of $date is "-0/2-/2007" as displayed. I found that if I insert this line just before the date parsing the result is as desired: $tmp_date = ereg_replace("/|-|:|\ |\.|,","",$tmp_date); $tmp_date becomes "20070221224533" and $date becomes "02/21/2007" Now I just need to find all of the other places in code where dates are used. This doesn't sound very "Fantastico". I'm not a PHP or MySQL expert...is there an easier solution?

I installed PHPAction...all went well...but... When I created a test item for auction there appears to be an issue with the timestamp. You can see the single item here: http://auction.johnlathrop.com/index.php Look at the date last created auctions...it is messed up. Dates are messed up in other display locations. I'm wondering if anyone has had success with this program...or has seen the problem as well. I thought I would ask before I start digging into it...

Thanks for the suggest Carl...I used the ":fail:" and now no more emails...

A few of days ago I started getting email failure notices...the type when you send an email to an invalid address. The strange thing is that I never sent the email. At first I thought the email was junk mail but made to look like a failure notice so I would look at it. But, now I'm not so sure. The following is the beginning of the email containing the email's meta data...any ideas?: Hi. This is the qmail-send program at s38.xrea.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <some-email-address@someotherdomain.net>: Sorry, no mailbox here by that name. (#5.1.1) --- Below this line is a copy of the message. Return-Path: <email@mytchdomain.com> Received: (qmail 18550 invoked by uid 89); 15 Apr 2006 17:54:20 +0900 Received: from dsl85-105-54677.ttnet.net.tr (85.105.213.149) by 192.168.1.127 with SMTP; 15 Apr 2006 17:54:20 +0900 Received: from keolc.vgwatq ([85.105.96.171]) by dsl85-105-54677.ttnet.net.tr (8.13.4/8.13.4) with SMTP id k3F8scZf042294; Sat, 15 Apr 2006 11:54:38 +0300 Message-ID: <000901c6606a$2a2a6897$ab606955@keolc.vgwatq> From: "Roland Frazier" <email@mytchdomain.com> To: "Some Guy" <email@someotherdomain.net> Subject: semiprecious Date: Sat, 15 Apr 2006 11:44:42 +0300 MIME-Version: 1.0 Content-Type: multipart/related; type="multipart/alternative"; boundary="----=_NextPart_000_0005_01C66083.4F77A06B" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 *TCH-Rob changed email address information

Thanks to all for the prompt reply! I got this message from NetworkSolutions: April 4th, 2006 11:00am EDT - This morning our collocation provider suffered a global outage from 7:56 a.m. to 10:02 a.m. (eastern) that impacted our systems. The provider’s outage affected access to Network Solutions products and services. The provider has resolved their systems and access to our services has been resorted. We appreciate your patience and apologize for the inconvenience. You may experience latency today as we continue to restore our services to full capacity.

I have noticed twice in about a month that my DNS, www.johnlathrop.com, does not respond to a ping. The last time this was temporary. This morning I'm still waiting for a successful ping. In each case I have been able to get to my site using the IP address. What could be the cause of this? UPDATE: About 5 minutes after this posting the PING started to respond.

I've been with TCH since 1/14/2005...a little more than one year. I have appreciated the service every day, but I must give a special thank you tonight. My little site, just a collection of information that I share with family and friends, typically uses only 3% of total bandwidth per month. For some reason, just 7 days into this month, the evil GoogleBot consumed 80% of my bandwidth. I opened a help ticket and got a prompt response from Robert Mulhern that included a recommendation on how to handle the bot and what to do if my consumed bandwidth goes to 100%. Well, the bandwidth went to 100% and my site was no more. I followed Robert's instructions and my site is back up within a 60 minute response time. That is awesome considering that it was "after hours". My site isn't much, but it is my little byte. Thanks for keeping it online!

When I look at CPanel's FTP Account Maintenance screen, particularly the links at the bottom, I see my password in the link. Is this necessary? Or is it an

I just got signed up today and things are ready to grow. Very easy! This is geek heaven!