5.0 Build 435 errors after 'Add Template to Project'

Markk,
please post your project to Demo Account and send the URL to support@xlinesoft.com for investigation.

Just uploaded the new build 444 and new calendar fix and am having issues with the calendar template. I am getting a dbconnection.php file error.
Technical information

Error type 256

Error description 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 'limit 0,20' at line 1

URL www.isp-vft.com/customers/monthly_list.php?

Error file /usr/local/4admin/apache/vhosts/isp-vft.com/httpdocs/customers/include/dbconnection.php

Error line 34

SQL query limit 0,20

Solution
This is a general error. It occurs when there is an error in event code or in SQL.
I have applied the calendar to the earlier version of 435 and not sure if it's left over remnants that are giving me problems. I need to access my previous information and site, is there a way to just remove the calendar so I can start clean?
Thanks for your help,
Noal

Noal,
To remove calendar from your project just remove all tables created with calendar template and rebuild your project.

Also you can publish your project on the Demo Account and send the URL to support@xlinesoft.com for investigation.

Noal,

Running PHPrunner 5.0 Build 448.
I've deleted the tables and all files, plus reloaded the project. One thing I have noticed is that once I clean out the calendar tables and files then attempt to re-login it tries to take me to one of the calendar pages I have deleted (which obviously is no longer there). Is their a way to purge this information without getting into my SQL database file. I'm assuming that it is pulling a recent visit associated with my user. For example, when logging in it takes me to the calmonthly_list.php file at which point I receive an error of "You don't have permissions to access this table".
I'll tackle the calendar and PHP/SQL errors after I figure this part out.
Thank you.

Hi,
first open project file in any text editor and remove Calendar template name in it.

<m_strBusinessTemplateName>Calendar</m_strBusinessTemplateName>

Then remove index.htm file from generated output directory and rebuild your project.

Hi,

I deleted the Calendar name from the project with a text editor, deleted the index.htm file, rebuilt the project, uploaded new files and still the same thing. It still kept directing me to a calmonthly_list.php file which was part of my old attempt at the calendar.
I actually solved the problem file doing a search of my valid built files and found that the /include/events.php file was showing the calmonthly_list.php as a redirect. I changed the URL to a valid one within my project and it works fine. It appears that the re-build wasn't updating the events.php file
Thanks for your help,
Noal

Noal kindly sent me this addendum to his post(s), which I thought might be helpful to others, too, so I am posting it here:

"

In the include/events.php file was the following (just a snippet):
//** Redirect to another page ****

header("Location: calmonthly_list.php");

exit();

}
For whatever reason, the "calmonthly_list.php" was continually listed as a redirect upon building the files, even though this was remnants of a calendar template which I had deleted. I went ahead and changed the "calmonthly_list.php" to "_Customers_list.php" (one of my own internal pages) so now when I login in it takes me to that page. I'm sure this is a temporary fix until it gets wrung out but it eliminated frustrating error pages our users were seeing by being navigated to the calmonthly_list.php page.
Hope this helps,
Noal

"
Thanks to everyone!,

Ken