Example 2 didn't work

Installation Problems And Solutions

Example 2 didn't work

Postby sg552 » Thu May 30, 2013 7:35 pm

Hi, Example 1 works for me but unfortunately join table Example 2 didn't work. I get this error:

There was a problem with the response text



<b>Notice</b>: Trying to get property of non-object in <b>C:\xampp-portable\htdocs\mate\Common.php</b> on line <b>41</b>

string(0) ""


How to solve this problem. Thanks in advance.
Attachments
Image 1.png
Image 1.png (68.94 KiB) Viewed 16919 times
sg552
 
Posts: 12
Joined: Wed Mar 23, 2011 1:58 pm

Re: Example 2 didn't work

Postby admin » Thu May 30, 2013 8:16 pm

Can you change line line 41 in Common.php from
Code: Select all
$message = sprintf($this->langVars->errInScript,$file,$line,$message);

to
Code: Select all
$message = sprintf('An error occurred in script %s on line %s: %s',$file,$line,$message);

And see if it gives you a more detailed error message.
admin
Site Admin
 
Posts: 1502
Joined: Fri Jul 11, 2008 1:34 am

Re: Example 2 didn't work

Postby sg552 » Thu May 30, 2013 9:11 pm

Hi, here is the new error output:

There was a problem with the response text

string(641) "An error occurred in script C:\xampp-portable\htdocs\mate\php\AjaxTableEditor.php on line 222:
<br />There was an error executing the following query:
select `login_info`.`id`,
concat(employees_c00c6_0.first_name,' ',employees_c00c6_0.last_name) as `employee_id`,
`login_info`.`login`,
`login_info`.`password`,
`login_info`.`account_type`,
date_format(test_date,"%d %M %Y") as `test_date`
from login_info
left join `employees` as `employees_c00c6_0` on `login_info`.`employee_id` = `employees_c00c6_0`.`id`
order by `employee_id` asc limit 0, 20

mysql said:
Unknown column 'test_date' in 'field list'"


Appreciate your reply. Thank you. :)
sg552
 
Posts: 12
Joined: Wed Mar 23, 2011 1:58 pm

Re: Example 2 didn't work

Postby sg552 » Fri May 31, 2013 6:17 am

I remove this line:

Code: Select all
      $tableColumns['test_date'] = array('display_text' => 'Test Date', 'perms' => 'EVCTAXQSHO', 'display_mask' => 'date_format(test_date,"%d %M %Y")', 'calendar' => array('format' => '%d %B %Y', 'reset' => true),'col_header_info' => 'style="width: 250px;"');


from Example2.php and it's now worked. I'm not sure what the significant because it's looks like a test code.

Thank you.
sg552
 
Posts: 12
Joined: Wed Mar 23, 2011 1:58 pm

Re: Example 2 didn't work

Postby admin » Fri May 31, 2013 5:18 pm

That shouldn't be in there, I've removed it from the code.
admin
Site Admin
 
Posts: 1502
Joined: Fri Jul 11, 2008 1:34 am


Return to Installation

Who is online

Users browsing this forum: No registered users and 2 guests

cron