Page 1 of 1

Oh no a bad start

PostPosted: Tue Aug 23, 2011 6:12 pm
by thesnowsnake
I have given up on LOGO so I have decided to use dataface. I hope I can rebuld all to code I have already slapped together. I have spent over one year to get this simple web data site going ...Then a update by meto joomla 1.7 and a update on LOGO has killed my code. And I can't get support right now because the proggramer has other interests (DANG) Lets get started. Here is the first problem:



Fatal error: Error performing mysql query to get column information from table 'clientbackupjuly26_11'. The mysql error returned was : 'Table 'iouguyc1_iou.clientbackupjuly26_11' doesn't exist'.
On line 477 of file /home/iouguyc1/public_html/dataface/Dataface/Table.php in function printStackTrace()
On line 2375 of file /home/iouguyc1/public_html/dataface/Dataface/Table.php in function Dataface_Table(client backup july26_11,Resource id #10,)
On line 977 of file /home/iouguyc1/public_html/dataface/Dataface/Application.php in function loadTable(client backup july26_11)
On line 1728 of file /home/iouguyc1/public_html/dataface/Dataface/Application.php in function handleRequest()
On line 5 of file /home/iouguyc1/public_html/iouguyc1_iou/index.php in function display()
in /home/iouguyc1/public_html/dataface/Dataface/Table.php on line 477

Re: Oh no a bad start

PostPosted: Tue Aug 23, 2011 6:36 pm
by shannah
Well... the error says it all. The table "clientbackupjuly26_11" doesn't exist in your database. Check your conf.ini file for typos on table names.

Re: Oh no a bad start

PostPosted: Tue Aug 23, 2011 9:43 pm
by thesnowsnake
Oh well it really does but I could live without it. So I will delete it. Hope that gets us started.

PS Thank you for the super speedy reply. SFU gave me my first 256 frame relay link for our isp WAY BACK Always enjoyed the relationship.
Again Thanks

Re: Oh no a bad start

PostPosted: Tue Aug 23, 2011 9:50 pm
by thesnowsnake
I had this software loaded a while ago and it worked well in the original form . Now it sees to be stuck on Primary key (no problem will add) Is this something new you added in the newer version?

Re: Oh no a bad start

PostPosted: Tue Aug 23, 2011 10:05 pm
by shannah
It has always required primary keys in all tables.

Re: Oh no a bad start

PostPosted: Wed Aug 24, 2011 5:41 am
by thesnowsnake
Very interesting I knew that I had a primary key on all my tables, but after all the updates with Joomla and LOGOs EtC. I find that a lot were missing even in the joomla basic tables, thanks for pointing that out.

Ok Im up and running, WOW thats going to be a long run again.
Do you work with a group of students that aide you?
I only ask as I was Tutored by Dr. David Vooris in Brandon years ago, and that was a excellent learning enviroment for me.
Dataface is completely different from the software I was using but I know it will do the tricks and magic I need.
My ability to learn and knowledge of mysql is limited as many years have passed since my old Point Of Sale Days.
Inventory control etc was the main use of the turbo power database and C with Pascal mix.