Form was working, now giving HTTP 500 error

Hi,

I have an application form on a site where it worked perfectly all last year, facilitating applications from music students all over the world.

Now I've received a report of a problem with it and, sure enough, when I test it, it doesn't work - clicking on submit just gives a HTTP 500 error (in IE - Firefox just shows a blank page!).

I'm happy to supply login details if you're prepared to take a look... any help is gratefully received, as I need to fix this so applications can be received! Thank you!

The form is here: http://www.londonmasterclasses.com/index.php?option=com_chronocontact&Itemid=173

Thanks for any assistance you can provide, as always.

HI bazza_vr6,

The form looks OK and it submits OK at least as far as the Captcha Check so something is going wrong after that. A blank screen is often a sign of a PHP error so I suggest that you temporarily set Site Error Reporting to Maximum and see if you get a more meaningful error mesage.

Bob

Hi, Bob,

Thank you for your reply.

The (maximum) debug produces the following two errors:

Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/xxxxxx/public_html/components/com_chronocontact/chronocontact.php(53) : eval()'d code on line 41

Fatal error: Call to a member function bind() on a non-object in /home/xxxxxx/public_html/components/com_chronocontact/libraries/customcode.php(71) : eval()'d code on line 13

I find this all very mysterious, since I haven't changed anything on the site... unless your allusion to PHP issues is a hint that the hosting company may have changed something at a lower level that affects the website(?).

Barry

Hi bazza_vr6 ,

The error suggest a problem with the DB Save. I'd usually expect to see a problem with an input or column name with an odd character in it. All the input names in your form look OK though.

Please turn on the Site Debug temporarily and check the MySQL query that is being created by the DB Save action.

Bob

Hi, Bob,

The output from the debug shown below the form is:

Profile Information
Application afterLoad: 0.000 seconds, 0.23 MB
Application afterInitialise: 0.080 seconds, 3.65 MB
Application afterRoute: 0.088 seconds, 4.21 MB
Application afterDispatch: 0.313 seconds, 6.37 MB
Application afterRender: 0.359 seconds, 8.09 MB
Memory Usage
8569004
13 queries logged

SELECT *
FROM jos_session
WHERE session_id = '6a8d0974a5a436d503388ea2f80107a8'
DELETE
FROM jos_session
WHERE ( time < '1326133276' )
SELECT *
FROM jos_session
WHERE session_id = '6a8d0974a5a436d503388ea2f80107a8'
UPDATE `jos_session`
SET `time`='1326135976',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1326135968;s:18:\"session.timer.last\";i:1326135968;s:17:\"session.timer.now\";i:1326135974;s:22:\"session.client.browser\";s:67:\"Mozilla/5.0 (Windows NT 5.1; rv:9.0.1) Gecko/20100101 Firefox/9.0.1\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:64:\"/home/xxxxxx/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}'
WHERE session_id='6a8d0974a5a436d503388ea2f80107a8'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 173)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM `jos_chrono_contact`
WHERE `name` = 'ApplicationForm'
SELECT *
FROM `jos_chrono_contact`
WHERE `id` = '10'
SELECT *
FROM `jos_chrono_contact_plugins`
WHERE `form_id` = '10'
AND event IN ('ONLOAD','ONLOADONSUBMIT')
AND `name` = ''
SELECT *
FROM `jos_components`
WHERE `option` = 'com_chronocontact'
AND parent='0'
AND admin_menu_link='option=com_chronocontact'
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 173 OR mm.menuid = 0 )
ORDER BY position, ordering

0 legacy queries logged

Language Files Loaded

/home/xxxxxx/public_html/language/en-GB/en-GB.ini 1
/home/xxxxxx/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
/home/xxxxxx/public_html/language/en-GB/en-GB.com_chronocontact.ini
/home/xxxxxx/public_html/language/en-GB/en-GB.tpl_londonmasterclassesnew.ini
/home/xxxxxx/public_html/language/en-GB/en-GB.mod_jevents_legend.ini
/home/xxxxxx/public_html/language/en-GB/en-GB.com_jevents.ini 1
/home/xxxxxx/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None

Hi bazza_vr6 ,

Is this below the form when it is loaded? That won't help as the query is only On Submit - do you see any output then?

If this is the On Submit debug I see nothing there writing to the ChronoForms data table.

Bob

Hi, Bob,

You're right, this is what's shown below the form when it is first loaded. When I click on submit (with debug still on) there is no more output except for the two errors (parse error, fatal error) as per my previous post.

Barry

Hi Barry,

I checked the form again and all the input names there look OK. What are the column names in the table - can you dump a CREATE statement from PHPMyAdmin?

Bob

Hi, Bob,

If I understood your request correctly, then I think you're asking for this (but let me know if I'm wrong!):

-- phpMyAdmin SQL Dump
-- version 3.4.7.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 11, 2012 at 01:43 PM
-- Server version: 5.1.56
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `xxxxxx_xxxxxx_xx`
--

-- --------------------------------------------------------

--
-- Table structure for table `jos_chronoforms_ApplicationFormIncBursary`
--

CREATE TABLE IF NOT EXISTS `jos_chronoforms_ApplicationFormIncBursary` (
  `cf_id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) NOT NULL,
  `recordtime` varchar(255) NOT NULL,
  `ipaddress` varchar(255) NOT NULL,
  `cf_user_id` varchar(255) NOT NULL,
  `LoginName` varchar(255) NOT NULL,
  `Password` varchar(255) NOT NULL,
  `ConfPassword` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `Addr1` varchar(255) NOT NULL,
  `Addr2` varchar(255) NOT NULL,
  `TownCity` varchar(255) NOT NULL,
  `CountyState` varchar(255) NOT NULL,
  `Postcode` varchar(255) NOT NULL,
  `Country` varchar(255) NOT NULL,
  `TelNo` varchar(255) NOT NULL,
  `Age` varchar(255) NOT NULL,
  `Arrival` varchar(255) NOT NULL,
  `Departure` varchar(255) NOT NULL,
  `URL1` varchar(255) NOT NULL,
  `URL2` varchar(255) NOT NULL,
  `URL3` varchar(255) NOT NULL,
  `Upload1` varchar(255) NOT NULL,
  `Upload2` varchar(255) NOT NULL,
  `Upload3` varchar(255) NOT NULL,
  `radio0` varchar(255) NOT NULL,
  `radio1` varchar(255) NOT NULL,
  `radio2` varchar(255) NOT NULL,
  `RecLetter1` varchar(255) NOT NULL,
  `RecLetter2` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `MusEd` longtext NOT NULL,
  `Bursary_Application` longtext NOT NULL,
  `Gender` varchar(255) NOT NULL,
  `Expertise` varchar(255) NOT NULL,
  `Paypal Payment` varchar(255) NOT NULL,
  PRIMARY KEY (`cf_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=219 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Hi Barry,

Perfect thank you. I think that the problem is the space in here

`Paypal Payment` varchar(255) NOT NULL,

Can you make that Paypal_Payment please - and make any corresponding changes to the form code.

Bob

How will I ever live down the shame and embarrassment of having caused my own form to fail by carelessly including a space in a field name (for a field that the form isn't even linked to!)????

🙄

Thank you again, Bob, for your unrivalled expertise!