Page 1 of 1

Help Im in despair

Posted: Fri Mar 01, 2013 3:41 am
by painatal
Guys I've made a nuBuilder backoffice, followed the tutorials. All good.
Detected some problems with the dropdows since i cant add ' to the queries cause it escapes those characters. Anyways I solved that inserting directly into the DB.

Problem is when i try to add something via a form to a database it just doesnt add. Returns me to the form screen and produces no output. Is there anyway i can check the queries being made or is this an easy to solve problem?

Btw the table has an INNER JOIN with another table but again, it used to work, i dunno what happened.

Thank you for any help

Re: Help Im in despair

Posted: Sat Mar 02, 2013 12:55 am
by admin
painatal,

See if any of these posts answer your problem..

http://forums.nubuilder.cloud/search.php? ... +%2Bsave++

For your first problem, this might help..
http://forums.nubuilder.cloud/search.php? ... ic++escape

Steven

Re: Help Im in despair

Posted: Sat Mar 02, 2013 3:12 pm
by painatal
That solves the first problem, as for the second problem i've searched for most of those posts none helped.

I actually solved the problem by removing the foreign key, and i had a discrepancy between the field names on the table and the ID's I was using on the lookup. Hope this saves someone the time it took me.

Also as a suggestion to this forum I'd advice not requiring all the posts to be accepted. It would bring a lot more discussion to this forum.

Anyway thank you for the help.

Re: Help Im in despair

Posted: Sun Mar 03, 2013 8:48 pm
by painatal
EDIT: PROBLEM NOT SOLVED

Re: Help Im in despair

Posted: Mon Mar 04, 2013 12:20 pm
by massiws
painatal,
can't you get more information reading php log file?

Max

Re: Help Im in despair

Posted: Fri Mar 08, 2013 7:56 pm
by painatal
Hey, I didn't know nuBuilder had that kind of log. Anyways I solved it.

My foreign key was not the primary key but an index of the other table. I changed it to the primary key. Its a better db design and it works just the same.

EDIT: Had to remove the foreign key in the end.
SOLVED

Re: Help Im in despair

Posted: Wed Mar 13, 2013 5:14 am
by admin
.