[phpws-comm-auto] [ phpwebsite-comm-mod/phpwsbusinesses-1535111 ] Mod/phpwsbusinesses

[SourceForge.net <no...@so...>]

mod/phpwsbusinesses item #1535111, was opened at 2006-08-05 10:54
Message generated for change (Comment added) made by azcappy
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=742476&aid=1535111&group_id=81360

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: azcappy (azcappy)
Assigned to: Nobody/Anonymous (nobody)
Summary: Mod/phpwsbusinesses

Initial Comment:
I installed the phpwsbusinesses module and it allowed 
me to enter my business using the Add My Business 
link, but it gives me an unknown SQL error when I try 
to add using the Add New Business link.

I thought maybe it was because I left a field blank so 
I tried it again making sure there was something in 
every field. Still gave the same unknown SQL error.

----------------------------------------------------------------------

>Comment By: azcappy (azcappy)
Date: 2006-08-05 11:14

Message:
Logged In: YES 
user_id=1569397

Here is an example of the error:

SQL: insert mod_phpwsbusinesses_businesses (image, 
sw_comments, sw_anonymous, expiryDate, firstname, 
middlename, lastname, prefix, suffix, email, 
phone_tollfree, phone_work, phone_fax, company_name, 
company_title, company_street, company_city, company_state, 
company_zip, company_country, company_website, comments, 
visibility, mine, custom1, custom2, custom3, custom4, 
custom1_priv, custom2_priv, custom3_priv, custom4_priv, 
owner, editor, ip, label, created, updated, hidden, 
approved, id) values (NULL, '1', '0', '2007-08-05 
12:00:00', 'Michael', 'D.', 'Usrey', 'Mr.', '', '', '', '602
-255-5578', '', 'Arizona Braille And Talking Book 
Library', 'Machine Supervisor', '1032 N. 32nd 
St.', 'Phoenix', 'AZ', '85009', 'USA', '', '', '0', '1', 
NULL, NULL, NULL, NULL, NULL, NULL, NULL, 
NULL, '', '', '71.209.183.21', 
NULL, '1154801585', '1154801585', '0', '1', 2)
unknown error

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=742476&aid=1535111&group_id=81360