Create table timeouts and Enable Server Side Validation

I have Version 1.5.15 and latest version of Chrono. Let me say I am new to Chronoforms and love it so far, btu I have two problems I cannot fix at the moment.

One is that my FF and IE timeout when I try to create tables when when I follow the tutorial, I have created multiple forms and none of them have been able to create tables

The second is the password validation thing is not working and I have tried both of these, my passwords are displayed as if they did not match

<?php global $mainframe; if ( JRequest::getVar('text_3') != JRequest::getVar('text_4') ) return 'Sorry, your passwords do not match, please try again!'; ?>

<?php
global $mainframe;
$text_3 = JRequest::getVar('text_3');
$text_4 = JRequest::getVar('text_4');
if ( $text_3 != $text_4 ) {
return 'Please be sure your passwords match';
}
?>

Hi mangiok,

I've no idea why you'd get a time out creating tables unless there are some broken input names in your code. You could turn Site DeBug on and see if the SQL is output.

The password validation code looks OK. You have this in the Server Side Validation box and ServerSide validation is turned on??

Bob

Thank you for your answer😀

I will give you a proper reply in about an hour once I am at home

Password validation
I had wrote the "t" in capital, Text_4 instead of text_4
This has been resolved🙂

Create table
What am I supposed to look at at the debug area?

Hi mangiok,

If you turn SiteDebug on in the Site Global Configuration panels then all of the page MySQL statement are output to the debug module. Look through these for the one writing to your table and see what the query is.

Bob

When I am at the page with the imaged displayed, I get

---

Profile Information
Application afterLoad: 0.007 seconds, 0.32 MB
Application afterInitialise: 0.122 seconds, 3.74 MB
Application afterRoute: 0.122 seconds, 3.74 MB
Application afterDispatch: 0.174 seconds, 5.64 MB
Application afterRender: 0.253 seconds, 6.41 MB
Memory Usage
6765984
16 queries logged.

   1.
      SELECT *
        FROM jos_session
        WHERE session_id = 'spmp7vr7c4k2tsjbna78cvgaj2'
   2.
      DELETE
        FROM jos_session
        WHERE ( time < '1263965181' )
   3.
      SELECT *
        FROM jos_session
        WHERE session_id = 'spmp7vr7c4k2tsjbna78cvgaj2'
   4.
      UPDATE `jos_session`
        SET `time`='1263968481',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1',`data`='__default|a:8:{s:15:\"session.counter\";i:7;s:19:\"session.timer.start\";i:1263968048;s:18:\"session.timer.last\";i:1263968292;s:17:\"session.timer.now\";i:1263968437;s:22:\"session.client.browser\";s:88:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:4:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":7:{s:23:\"com_modulesfilter_order\";s:10:\"m.position\";s:27:\"com_modulesfilter_order_Dir\";s:0:\"\";s:23:\"com_modulesfilter_state\";s:0:\"\";s:26:\"com_modulesfilter_position\";s:1:\"0\";s:22:\"com_modulesfilter_type\";s:1:\"0\";s:26:\"com_modulesfilter_assigned\";s:1:\"0\";s:17:\"com_modulessearch\";s:0:\"\";}}s:11:\"application\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}s:6:\"global\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";i:20;}}}s:11:\"com_modules\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:9:\"name\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:21:\"name@email.com\";s:8:\"password\";s:65:\"f8371eefc124fda29c67eed62a7dce83:vgINfLR4lawpQryftyCyE9MRHlCMouon\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2009-11-15 09:12:58\";s:13:\"lastvisitDate\";s:19:\"2010-01-20 03:22:41\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:57:\"admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=-5\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;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:75:\"/var/www/vhosts/website.com/httpdocs/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\":5:{s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:2:\"-5\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"5a8f3539c913bcd65a515368bde53c22\";}'
        WHERE session_id='spmp7vr7c4k2tsjbna78cvgaj2'
   5.
      SELECT *
        FROM jos_components
        WHERE parent = 0
   6.
      SELECT folder AS type, element AS name, params
        FROM jos_plugins
        WHERE published >= 1
        AND access <= 2
        ORDER BY ordering
   7.
      SELECT *
        FROM `jos_components`
        WHERE `option` = 'com_chronocontact'
        AND parent='0'
        AND admin_menu_link='option=com_chronocontact'
   8.
      SHOW TABLES
   9.
      SELECT *
        FROM jos_chrono_contact
        WHERE id = '5'
  10.
      SELECT template
        FROM jos_templates_menu
        WHERE client_id = 1
        AND menuid = 0
  11.
      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 <= 2
        AND m.client_id = 1
        ORDER BY position, ordering
  12.
      SELECT a.name, a.admin_menu_link, a.admin_menu_img
        FROM jos_components AS a
        INNER JOIN jos_components AS b
        ON b.id = a.parent
        WHERE b.OPTION = 'com_chronocontact'
        AND b.parent = 0
        ORDER BY a.ordering ASC
  13.
      SELECT a.*, SUM(b.home) AS home
        FROM jos_menu_types AS a
        LEFT JOIN jos_menu AS b
        ON b.menutype = a.menutype
        GROUP BY a.id
  14.
      SELECT *
        FROM jos_components
        WHERE `option` <> "com_frontpage"
        AND `option` <> "com_media"
        AND enabled = 1
        ORDER BY ordering, name
  15.
      SELECT COUNT(*)
        FROM jos_messages
        WHERE state = 0
        AND user_id_to = 62
  16.
      SELECT COUNT( session_id )
        FROM jos_session
        WHERE guest <> 1

0 legacy queries logged.

Language Files Loaded

    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.plg_system_debug.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_chronocontact.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.tpl_khepri.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.mod_submenu.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_chronocontact.menu.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.mod_title.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.mod_toolbar.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.mod_menu.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_joomlapack.menu.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_cbcontact.menu.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_ccquery.menu.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_chronoconnectivity.menu.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_comprofiler.menu.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_waticketsystem.menu.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_contact.menu.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_mcs.menu.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_jce.menu.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_joomlaxplorer.menu.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_jtaghelpdesk.menu.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_poll.menu.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_projectfork.menu.ini
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_search.menu.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_banners.menu.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_newsfeeds.menu.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.com_weblinks.menu.ini 1
    * /var/www/vhosts/website.com/httpdocs/administrator/language/en-GB/en-GB.mod_status.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None

------

Too much info?

Hi Magniok,

But that's not when you get the timeout error is it?

Try clicking the 'tick' icon in the blue bar to select all the fields then the 'disk' icon at the top to save the table. If the table already exists then you'll need to delete it first (or use a different table name).

Bob

I clicked on the little "tick" and it still timed out after pressing save.
This happens both while using firefox and IE. I cannot see anything in debug since my web browser times out.

And let me point out how I am surprised to be getting some quick and good help🙂

Hi mangiok,

There's no obvious reason for this. I don't think it is browser related; it might be a server problem though I suspect not.

[sendfb][/sendfb]
Bob

Did you get the file I sent through PM?

Hi mangiok,

Unfortunately it works OK here :-(

Here's the MySQL to create the table from PHPMyAdmin

DROP TABLE IF EXISTS `jos_chronoforms_register`;
CREATE TABLE  `jos_chronoforms_register` (
  `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,
  `text_0` varchar(255) NOT NULL,
  `text_1` varchar(255) NOT NULL,
  `text_2` varchar(255) NOT NULL,
  `text_3` varchar(255) NOT NULL,
  `text_4` varchar(255) NOT NULL,
  PRIMARY KEY (`cf_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Bob

I suppose I am still having permissions issue. I was having the weirdest issue on Media Temple.

Thanks, I'll create tables manually from now on🙂