FORUMS


The Form Tools forums are no longer active, but the old posts have been archived here. Please see the Help page on how to get help / report issues.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
error
#1
I'm seeing a nasty error when my user tries logging in. The interesting thing is all seems to work on the back end. I can see within the module each time the user "attempts" to log in, only...this is what they see...

Code:
Notice: Undefined index: form_id in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/modules/submission_accounts/users/index.php on line 17

Notice: Undefined index: view_id in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/modules/submission_accounts/users/index.php on line 18

Notice: Undefined index: submission_id in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/modules/submission_accounts/users/index.php on line 19

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/views.php on line 768

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/views.php on line 230

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/forms.php on line 427

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/forms.php on line 467

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/forms.php on line 493

Notice: Undefined index: access_type in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/forms.php on line 429

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/forms.php on line 433

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/views.php on line 115

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/views.php on line 536

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/views.php on line 404

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/views.php on line 654

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/views.php on line 230

Notice: Undefined index: access_type in /data/16/1/160/162/1812814/user/1964174/htdocs/admin/global/code/views.php on line 120
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 'ORDER BY list_order' at line 4

Any thoughts!? Did I break something!

Here's the actual page so you can see it in action...
http://pikespeakchallenge.com/admin/modu...?form_id=5

Username: b.shephard@walkingby.com
Password: test

Thanks so much!
Brian

UPDATE: Nearly minutes after I typed this out...I noticed I didn't have my sub domain of "www" in place. Simply adding this corrected the issue. Is this a bug?

...On a side note...Since I'm the guy who goes wild with customization...

Here's my scenario...

This site has a register form which processes a payment and saves their info within Form Tools. I have a sql query on another form which displays all registered members in a list menu. This is a donation form. The concept is to allow someone the ability to donate to a specific registered member. This form also processes a payment and saves the data within Form Tools.

Upon registering as a member...their confirmation email includes a link which allows them to view a running list of their donation totals.

Everything above is in place except the working link to view donation totals. I discovered this module and figure it should be a perfect "simple" solution to this. The 2 issues I have are, I do not want them to be able to update any information...simply view it. The other is I need my "total" field to use a SUM query to update and display all donations. The way I see it...I have multiple options to accomplish this. I've toyed with the idea of creating a second table in my database that displays ONLY the registered members name...and the amount field. I just haven't figured the "running total" within Form Tools out yet, as well as disabling the "update" option for my users.

I know this was quite the novel! I do apologize! ...but any tips on accomplishing this would be greatly appreciated!

Thanks in advance!
Brian
Reply
#2
Hey Brian,

Good grief - I'm sorry I missed this post. I've just been trolling the forums and came across this one.

Eesh! Very ugly errors indeed. Yeah, the "www" vs "non-www" is such a pain. The problem is bloomin' PHP sessions. They won't work when moving from one page to the other. If you store a value on http://www.yoursite.com, they can't be read on yoursite.com. They're regarded as different sites. So a bug...? Yeah, maybe. But I'm not sure how to solve it, other than moving to database sessions (just include $g_session_type = "database"; to your config.php file).

Quote:The 2 issues I have are, I do not want them to be able to update any information...simply view it

No problem. Just create a new View that only allows for viewing the fields, not editing them. Then assign that View to the submission account, in the main admin section the module.

Anyway, hope all is well, Brian.

- Ben
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)