Open Source Training Seminar


Not Logged in - No Account?

Don't have an account? Registering an account with us allows you to post to the forums, easily track new posts, subscribe to threads, pm (private message) other forum members, and receive periodic news letters (you can opt out if you desire). Once you are logged in this message will no longer appear. If you don't have an account, you can create one by registering here. Lost your password, request a new password. We respect your privacy which means we collect minimal information when you register and we do not resell that information or use it in any objectionable way. You can review our privacy policy for full details.


Various Errors with VoiceMail Blasting

drmessano's picture
Posted January 15th, 2008 by drmessano (Contributor)

FATAL ERROR

INSERT INTO vmblast (grpnum, description, audio_label, password) VALUES (, '', '-1', '') [nativecode=1064

** 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 ' '', '-1', '')' at line 1]

SQL - INSERT INTO vmblast (grpnum, description, audio_label, password) VALUES (, '', '-1', '')

 

I've gotten several different errors as i've tried to add the first group... this one as well:

 

FATAL ERROR

INSERT INTO vmblast_groups (grpnum, ext) values ('','') [nativecode=1062 ** Duplicate entry '' for key 1]

error adding to vmblast_groups table

 

Any ideas?

 

dm


__________________


‹ IMAP voicemail error upgrading from 2.4.0beta2.0 ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

hmm - odd, before digging in

p_lindheimer's picture
On January 15th, 2008 p_lindheimer (Developer) said:

hmm - odd,
before digging in - can you just un-install it and then reinstall it to clean up the database and then see if you keep getting issues? At some point early on I know there were some problems, I thought they had been addressed.
p


__________________

Philippe Lindheimer - FreePBX Project Leader
FreePBX Training Opportunities - Click Here
Get Official Paid Support - Click Here


Tried that quite a few

drmessano's picture
On January 15th, 2008 drmessano (Contributor) said:

Tried that quite a few times..

Also, I started off with the first beta, if that helps any.

dm


then do the following: 1.

p_lindheimer's picture
On January 15th, 2008 p_lindheimer (Developer) said:

then do the following:

1. uninstall the module
2. install the module
3. re-create the error by giving me exact step by step sequence of how you do it and where the errors pop up

Then if I can make it fail here I can debug it.

night


__________________

Philippe Lindheimer - FreePBX Project Leader
FreePBX Training Opportunities - Click Here
Get Official Paid Support - Click Here


Change Ext to 690 Change

drmessano's picture
On January 15th, 2008 drmessano (Contributor) said:

Change Ext to 690

Change Group Description to "2l2o VM Blast" (no quotes)

Audio Label: Left at default "Read Group Number"

No Password

Selected 4 of my Voicemail boxes.

Did NOT select "Default VM Blast Group"

 

Result:

 

INSERT INTO vmblast (grpnum, description, audio_label, password) VALUES (, '', '-1', '') [nativecode=1064 ** 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 ' '', '-1', '')' at line 1]SQL -
INSERT INTO vmblast (grpnum, description, audio_label, password) VALUES (, '', '-1', '')

 

Ran AGAIN, this time SELECTING "Default VM Blast Group"

 

FATAL ERROR
INSERT INTO vmblast_groups (grpnum, ext) values ('','') [nativecode=1062 ** Duplicate entry '' for key 1]

error adding to vmblast_groups table

 

dm

I too have the same problem

bpps's picture
On January 15th, 2008 bpps (tadpole) said:

FATAL ERROR
INSERT INTO vmblast (grpnum, description, audio_label, password) VALUES (, '', '-1', '') [nativecode=1064 ** 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 ' '', '-1', '')' at line 1]SQL -
INSERT INTO vmblast (grpnum, description, audio_label, password) VALUES (, '', '-1', '')

amd also only did as you did above

I am using MySQL - 5.0.48 if that might help also the default value in the database for audio label is -1 i tried clearing that but still get the same problem


I can't re-pro: I just did

p_lindheimer's picture
On January 15th, 2008 p_lindheimer (Developer) said:

I can't re-pro:

I just did the following:

1. Delete all my current VMBlast Groups
2. Reload
3. Uninstall VMBlast in Module Admin
4. Reload
5. Install VMBlast
6. Reload
7. Make the exactly described config as above, same name, extension number and chose 4 extensions
8. Submit
9. Reload

VMBlast is version 2.4.1

Hard to find the bug if I can't repro???


__________________

Philippe Lindheimer - FreePBX Project Leader
FreePBX Training Opportunities - Click Here
Get Official Paid Support - Click Here


Ok, the 2.4.2 fixes the

drmessano's picture
On January 15th, 2008 drmessano (Contributor) said:

Ok, the 2.4.2 fixes the adding issue.. Here's more odd behavior

I fill in the info to add a group.. check the "Default" checkbox, Submit Changes, Apply at the top.. The group adds, but I can not call it. "Your call can not be completed as dialed". I check the group, and the Default checkbox didn't take. So I check it, Submit, Apply. It now works.

I fill in the info for another group, Submit Changes. NO PROMPT for Apply. I tried to call it, and recieved the same message..It's more obvious with this one that no config chances were written.. so I click the entry at the right for that second group, Submit again. This time I CAN Apply. It also now works.

I fill in the info for yet another group, Submit Changes. NO PROMPT for Apply again. Same thing.

Seems theres a couple different issues to isolate... The Default Group checkbox, not prompting to apply subsequent extensions.

dm