[SOLVED] Incorrect table name '' Errors!

This topic is locked

[SOLVED] Â Incorrect table name '' Errors!	2/27/2011 8:07:18 PM
PHPRunner General questions
B BrownCHiLD author Hi guys Im coming from PHPMaker , and i wanted to try out PHPRunner... Downloaded the latest version, and everything was self explanatory.. but then when viewing my project from my server I was getting table errors Here's the weird part... some tables work ok, and some gets this error.... i tried to study the differences that would've cause these errors but no they're all same.. here's another weird part, i have a very simple table named categories, that has a few columns only.. one that's getting the said error in PHP RUNNER.. i noticed that in PHP Runner one can create a databse table during the project creating phase right? so i did , i built the exact same table under PHPRUnner NEW TABLE options, and the name is categories2 .. to my surprise it worked.. so im baffled.. anyway here are the files.. includes the output, the project file as well as the SQL Dump file of my database.. http://cl.ly/4t9T can anyone tell me what's wrong? i spent hours on this and still no solution.. I went back to PHPMaker for now and there's zero problem... but i really wana see what PHPRunner has to offer... Regards TJ PS here's my environment: Windows 7 X64 Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 MYSQL 5.1.41

Mark as Solved Mark as not solved

6 replies


P	procheck 2/27/2011
	You should email support directly. You will receive faster service.


	Sergey Kornilov admin 2/27/2011
	Make sure enum field 'cat_type' is not setup as database-based lookup wizard with no source table selected. You can setup it as a hardcoded Lookup wizard and add list of values manually. If this doesn't help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.


B	BrownCHiLD author 2/28/2011
	Make sure enum field 'cat_type' is not setup as database-based lookup wizard with no source table selected. You can setup it as a hardcoded Lookup wizard and add list of values manually. If this doesn't help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. hi... i dont think it's setup as lookup coz when loading the tables i went thru the phprunner wizard just clicking next/defualt to test things... but nevertheless ok so where do i check this? at w/c stage of the wizard?


	Sergey Kornilov admin 2/28/2011
	In Visual Editor double-click on the field and check settings under 'Edit as' tab.


B	BrownCHiLD author 3/2/2011
	In Visual Editor double-click on the field and check settings under 'Edit as' tab. kk i found it.. thanks next question though, why thoes phprunner default enum fields to a look up routine?? where enums should be none lookup! it has its own options/values set in the database, duh.. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=56839&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' /> Imagine if you have a table w/ lots of enum fields, and imagine if ur enum options were a lot, you'd have to manually enter those enum options 1 by 1 <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=56839&image=2&table=forumreplies' class='bbc_emoticon' alt=':(' />


	Sergey Kornilov admin 3/2/2011
	This is a bug in PHPRunner - enum fields are not handled properly at this moment. Will be fixed in the next version.

6 replies

Mark as Solved Reply