Thread: Advance blue voda form processor

After filling out the processor installation form and hitting "install now I recieve the message "could not connect to the database server" what to do?
Doors-of-hope-ministries.org

In the ABVFP installation panel, there is a yellow ? beside each field. Click there to get help.

Make sure you have created the database, created the user, and ADDED the user to the ABVFP related database

I have done that, and checked the upload there is one note though, "make sure that all files have permissions 644" and I have no clue what that is all about

Sometimes FTP changes the deafault permissions from 644 to something else, so i suggest that you check the files permissions.
Connect with FTP, go in the ABVFP folder, and right click on the files, from the right click menu select "Permissions" and make sure they are 644, if not change them to be so

Well I did that and now I am not permitted in

This is the message:
You don't have permission to access /ABVFP/dbts_install.php on this server.

You have, somehow, changed the permissions of the files or of the entire folder.
The folder needs to be 755, the files inside it must be 644. Check it.

all files are 644 and folder755 and still getting "could not connect to the database server"

I got it, the user name in data base didnt match.

Hello, thanks in advance, I can´t make work the upload field in my form and now I am trying to instal AVBFP so it can be easy, I am having trouble to create the data base and the user. What I kave done is create a folder named ABVFP in the folder cpanel, but then how do i add a user?

thanks, I made all the things posted in adding an uploadform post..and I didn´t have results

Luis

The user is not added to the folder, but to the database. You need to create a database, in your Cpanel, then you create a user (you assign a username and a password) then you add this user to that database. Please watch this tutorial: http://www.vodahost.com/demowolf/cpa...eatemysql.html

Than you, I correct them

Now I have an other problem, when I receive the email the link of the URL for the archive in my data base is not completly underlined, I make bigger the browse button so I can have more characters but this don´t fix it.

How can I make to make URL appears complete underlined in my Email?

Does your URLs contain blank spaces ? If yes, the URLs will be broken anyway.

The browse button dimensions have nothing to do with it.

Ok, now ther is nothing to do with that, What i have done now is add more upload files and it is happening that they are uploaded but the link does not appears in my mail.

i have the following to add to my mail:

//Sending Email to form owner
$mailto = "info@ideaspersonales.com";
$mailsubj = "COTIZACION";
$mailhead = "From: $email\n";
reset ($HTTP_POST_VARS);
$mailbody = "Datos del cliente y link de archivos :\n";
while (list ($key, $val) = each ($HTTP_POST_VARS))
{
if ($key!="submit")
{
$mailbody .= "$key : $val\n";
}
}
$mailbody .= "File Link 1: $upload_URL\n"; //
$mailbody .= "File Link 2: $upload2_URL\n"; //
$mailbody .= "File Link 3: $upload3_URL\n"; //
$mailbody .= "If any link is broken, please copy and paste it in your browser's address bar\n";
mail($mailto, $mailsubj, $mailbody, $mailhead);
header("Location: uploadaction.html");

This is obviously a script that you have created using pieced from here and there, but it will not work. the routine that uploads the file to your site is NOT in there. Use the code in How to upload a file using a form or use Advanced BlueVoda Form Processor or you will not be able to upload your files.

Navaldesign I don´t paste all the script, now here it is complete, all files are in my public folder named uploads, thay are only not appearing in my email, just the first one, I will paste my e mail received under the php script:

<?php
// Receiving variables
@$email = addslashes($_POST['email']);
@$upload_Name = $_FILES['upload']['name'];
@$upload_Size = $_FILES['upload']['size'];
@$upload_Temp = $_FILES['upload']['tmp_name'];
@$upload2_Name = $_FILES['upload2']['name'];
@$upload2_Size = $_FILES['upload2']['size'];
@$upload2_Temp = $_FILES['upload2']['tmp_name'];
@$upload3_Name = $_FILES['upload3']['name'];
@$upload3_Size = $_FILES['upload3']['size'];
@$upload3_Temp = $_FILES['upload3']['tmp_name'];
// Validation for max file size
if ($upload_Size>0)
{
if( $upload_Size >1000000)
{
//delete file
unlink($upload_Temp);
header("Location: error.html");
exit;
}
}
if ($upload2_Size>0)
{
if( $upload2_Size >1000000)
{
//delete file
unlink($upload2_Temp);
header("Location: error.html");
exit;
}
}
if ($upload3_Size>0)
{
if( $upload3_Size >1000000)
{
//delete file
unlink($upload3_Temp);
header("Location: error.html");
exit;
}
}
if ($upload_Size>0)
{
$uploadFile = "uploads/".$upload_Name ;
@move_uploaded_file( $upload_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload_URL = "http://www.ideaspersonales.com/uploads/".$upload_Name ;
}
if ($upload2_Size>0)
{
$uploadFile = "uploads/".$upload2_Name ;
@move_uploaded_file( $upload2_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload_URL = "http://www.ideaspersonales.com/uploads/".$upload2_Name ;
}
if ($upload3_Size>0)
{
$uploadFile = "uploads/".$upload3_Name ;
@move_uploaded_file( $upload3_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload_URL = "http://www.ideaspersonales.com/uploads/".$upload3_Name ;
}
//Sending Email to form owner
$mailto = "info@ideaspersonales.com";
$mailsubj = "COTIZACION";
$mailhead = "From: $email\n";
reset ($HTTP_POST_VARS);
$mailbody = "Datos del cliente y link de archivos :\n";
while (list ($key, $val) = each ($HTTP_POST_VARS))
{
if ($key!="submit")
{
$mailbody .= "$key : $val\n";
}
}
$mailbody .= "File Link 1: $upload_URL\n";
$mailbody .= "File Link 2: $upload2_URL\n";
$mailbody .= "File Link 3: $upload3_URL\n";
$mailbody .= "If any link is broken, please copy and paste it in your browser's address bar\n";
mail($mailto, $mailsubj, $mailbody, $mailhead);
header("Location: thankyou_page.html");
?>

THIS IS THE MAIL I RECEIVED (HOW CAN I CHANGE THE ORDER THE DATA IS IN MY MAIL? THEY ARE NOT IN THE ORDER I WANT:

Datos del cliente y link de archivos :
email : foxjicuri********.com
cantidad_2 : 3
lacre2 :
cantidad3 : 6
azulejos3 :
otro_motivo_de_contacto : ll
Env&#237;ar_a_Domicilio :
tazas :
cantidad : 3
name : julio
File Link 1: http://www.ideaspersonales.com/uploads/pi&#241;as.jpg
File Link 2:
File Link 3:
If any link is broken, please copy and paste it in your browser's address bar

Thank&#180;s for everything!
Luis Arana

Use the following:

<?php

// Set file size limit

$size_limit = 1000000; // Set it to whatever size you want in Bytes
// Receiving variables
@$email = addslashes($_POST['email']);
@$upload_Name = $_FILES['upload']['name'];
$upload_Name_Name = str_replace(" ", "_", $upload_Name);
@$upload_Size = $_FILES['upload']['size'];
@$upload_Temp = $_FILES['upload']['tmp_name'];
@$upload2_Name = $_FILES['upload2']['name'];
$upload2_Name_Name = str_replace(" ", "_", $upload2_Name);
@$upload2_Size = $_FILES['upload2']['size'];
@$upload2_Temp = $_FILES['upload2']['tmp_name'];
@$upload3_Name = $_FILES['upload3']['name'];
$upload3_Name_Name = str_replace(" ", "_", $upload3_Name);
@$upload3_Size = $_FILES['upload3']['size'];
@$upload3_Temp = $_FILES['upload3']['tmp_name'];

// Validation for existing file and max file size

if ($upload_Size>0 and $upload_Size <= $size_limit)
{
$uploadFile = "uploads/".$upload_Name ;
@move_uploaded_file( $upload_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload_URL = "http://www.ideaspersonales.com/uploads/".$upload_Name ;
}
if ($upload2_Size>0 and $upload2_Size <= $size_limit)
{
$uploadFile = "uploads/".$upload2_Name ;
@move_uploaded_file( $upload2_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload2_URL = "http://www.ideaspersonales.com/uploads/".$upload2_Name ;
}
if ($upload3_Size>0 and $upload3_Size <= $size_limit)
{
$uploadFile = "uploads/".$upload3_Name ;
@move_uploaded_file( $upload3_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload3_URL = "http://www.ideaspersonales.com/uploads/".$upload3_Name ;
}
//Sending Email to form owner
$mailto = "info@ideaspersonales.com";
$mailsubj = "COTIZACION";
$mailhead = "From: $email\n";
reset ($HTTP_POST_VARS);
$mailbody = "Datos del cliente y link de archivos :\n";
while (list ($key, $val) = each ($HTTP_POST_VARS))
{
if ($key!="submit")
{
$mailbody .= "$key : $val\n";
}
}
$mailbody .= "File Link 1: $upload_URL\n";
$mailbody .= "File Link 2: $upload2_URL\n";
$mailbody .= "File Link 3: $upload3_URL\n";
mail($mailto, $mailsubj, $mailbody, $mailhead);
header("Location: thankyou_page.html");
?>

I have changed the code so if a file name contains whitespaces (blanks) the script will replace them with an underscore, so links should not result broken anymore.

To change the order of the data in your email (as well as the TAB order of your form fields) follow this simple procedure:

Right click on the field you want first, and select "Move to front".
repeat for all fields, in the order you want them to appear. include your submit and reset buttons.

Why don't you simply use ABVFP ?

It will do what you want, without need for coding.

I haved trouble trying to install ABVFP, I am going to try it another time and I will keep you informed, I mean the problem was I can&#180;t go to the folder AVBFP that I create on my public folder. I will check my acces to the folder

Naval, I have problems installing ABVFP when i try to acces to my data base, i have the following

Advanced Blue Voda Form Processor Installation
@ Copyright 2005- 2007 DBTechnosystems.com

Username for ABVFP:

Password for ABVFP:
Database Host:
Database Name
Database Username
Database Password:
Confirm Password:

Your Site

Your Email Address:

I have read and accept the End User License Agreement

I am creating a password that is the same for data base password.
When I create the user i put luisarana but when is created it says it has been created "luisara" now what i have to put in the form?

thanks for all!

luis arana

The database user creaton wizard will only accept up to 7 characters, so it truncates luisarana to luisara. Not only, but the actual user is cpusername_luisara (where cpusername is your Control Panel username)

It does the same for the Database name: it becomes cpusername_ABVFP.

Clicl on the yellow questionmarks to get the help window opened with instructions.