[phorm] [Phorm:] Re: Alert 010 - Unable to open DB variables file

  • From: webbbs@xxxxxxxxx
  • To: support@xxxxxxxxx
  • Date: 22 May 2003 23:26:05 -0000

The following new message has been posted on Phorm Support Forum at 
<http://www.phorm.com/support/>. 

*************************************************************************** 

  MESSAGE:  (#2725) Re: Alert 010 - Unable to open DB variables file 
            <http://www.phorm.com/support/?rev=2725> 
  AUTHOR:   Caleb Shiffer 
  DATE:     May 22, 2003 at 7:26 p.m. EST 

  Reply To: (#2723) Re: Alert 010 - Unable to open DB variables file 
  Author:   Patrick O'Hara 
  Date:     May 22, 2003 at 7:15 p.m. EST 

Thanks a lot -- I've got it working, although not as I'd planned, which is to 
be expected, lol. Here's my current script... 

<?php 
# This is the global configuration file. It's read every time Phorm runs. 
# If the form calling Phorm has a local (form-specific) configuration file, 
# settings in it will override settings here. 

# This variable indicates that a local config file is NOT required. 
$PHORM_RCONFIG = "N"; 
$PHORM_ALERTTO = "caleb.shiffer@xxxxxxxxxxxx"; // Change to your email address 
$PHORM_TO = "caleb.shiffer@xxxxxxxxxxxx"; // Change to your email address 
$PHORM_SUBJECT = "Form Data"; // The subject of the email message 
$PHORM_TMPL = ph_GENERIC; // A generic email template 
$PHORM_ACK = "ack.htm"; // A generic ack template 
$DHost = "localhost"; 
$DUser = "lebshif_lebshif"; 
$DPass = "xxxxxxxxx"; 
$DBase = "lebshif_tickets"; 
$PHORM_MYTABLE = "Tickets"; 
$PHORM_MYVARS = "email=email, AIM=AIM, bridge=bridge, ants=ants, 
nancies=nancies, 

Description=desc, TradeType=trade%, Have=have%, Need=need%"; 

?> 

And here's the XML dump from the DB: 

<?xml version="1.0" encoding="iso-8859-1"?> 

<!-- 
- 
- phpMyAdmin XML-Dump 
- version 2.4.0 
- http://www.phpmyadmin.net/ (download page) 
- 
- Host: localhost 
- Generation Time: May 22, 2003 at 06:20 PM 
- Server version: 4.0.12 
- PHP Version: 4.2.3 
- Database : 'lebshif_tickets' 
- 
--> 

<lebshif_tickets> 
<!-- Table Tickets --> 

<Tickets> 

<Have>Description of seats</Have> 

<Need>Description of seats</Need> 

<Description>Description of seats</Description> 

<email>chs22@xxxxxxxxxx</email> 

<AIM>Lebshiff21</AIM> 

<bridge>Lebshiff21</bridge> 

<ants></ants> 

<nancies></nancies> 

<TradeType>Description of seats</TradeType> 

</Tickets> 
</lebshif_tickets> 

Here's the form: http://www.lebshiff.com/trading.htm 

When visitors check off the tour dates they either "have" or "need" it's not 
transmitting the selections to the DB correctly, instead it's transmitting 
"Description of Seats" which is the data I'm entering in the large text box 
near the bottom of the page. Same thing goes for the TradeType fields. I'm 
assuming it has something to do with the "%" I used in those entries. Seeing 
my form, is there any way I can input the selections visitors choose for the 
"have" and "need" fields into only 2 columns in the database? I hope I'm being 
clear enough.... I really appreciate all your help :) 

*************************************************************************** 

This is an automatically-generated notice.  If you'd like to be removed from 
the mailing list, please visit Phorm Support Forum at 
<http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx  If 
you wish to respond to this message, please post your response directly to the 
board.  Thank you! 
-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing 
list. To send messages to the mailing list, simply send email to 
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe 
from the list by sending email to phorm-request@xxxxxxxxxxxxx with 
'unsubscribe' in the SUBJECT field.

Other related posts: