Author Topic: Error in loading database  (Read 2860 times)

jrudge

  • Posts: 4
    • View Profile
Error in loading database
« on: September 24, 2007, 10:54:17 pm »
Sir,
In the first step of installation when we install the database the error comes--->
"Creating config database table lm_config - Inserting example config data.
**Error inserting example config data."
When we looked in the code it was due to the code written in the editconf.php at line 1142 it was passing mtauth fields as TRUE but in database it is of type char(1) .
The problem was it was not accepting "true" so I changen it to  1 and than executed it and it worked.
Similar way there are certain places where I have to change the fields value.

Can you tell me please what is the reason behind it?

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Error in loading database
« Reply #1 on: September 25, 2007, 12:30:18 am »
Hi, this is apparently a mistake in the code that affects only some servers.  Seeing that you are on Windows from your other thread, perhaps it is Windows servers.  Had you not been able to sort this out on your own I would have been happy to connect to your server and apply the fixes.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

jrudge

  • Posts: 4
    • View Profile
succeded in installing database but failed in sending mail
« Reply #2 on: September 26, 2007, 06:00:09 am »
Hello sir,
Yes I am working on the windows server.
Now I am working on the WAMPP invironment . I have succeded in installing the complete database . But when I click on configuration it takes  me back to the login page and I was not able to login and do the configuration settings.
Please if you can tell what is the solution of it?

One more thing sir  I edited some code and I was able to login.I dont think changing the code is correct .But any how I logged in and I created a user by clicking User Database-> New User
I came through a warning saying :
"Warning: mail() [function.mail]: SMTP server response: 501 5.5.4 Invalid Address in D:\phproot\cellbucket\listmailpro\admin.php on line 2482"
When I printed all the things sended by me I got

emaiId--rmeel@example.com
Subject---Welcome!
body---Welcome to the pragya newsletter.
header----From: "Your Site Newsletter" Return-Path: rmeel@example.com MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Mailer: ListMail v1.87 X-LMP-Recipient: rmeel@example.com To: "Ravinder Meel"

These are the settings provided by me .For localhost I am using mail.example.com as my SMTP server host.
Please tell me what all things to be changed

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Error in loading database
« Reply #3 on: September 26, 2007, 04:27:02 pm »
The PHP mail() function used to send welcome, confirmation and some notification emails should be working as a part of your web hosting.  Please contact your web host and ask if they can make the PHP mail function available.  Some reference is here:

http://php.net/manual/en/function.mail.php

PS. I have removed the sensitive information from your posts.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

jrudge

  • Posts: 4
    • View Profile
problem in the code
« Reply #4 on: September 26, 2007, 10:21:59 pm »
Sir
There is no problem in the  PHP mail function available because the same thing is working for other scripts at local.
Before when my database was not configured properly then I received a blank welcome email but now when I configured the complete database it is not sending the email.
Please tell the complete solution of this problem.

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Error in loading database
« Reply #5 on: September 27, 2007, 12:00:09 am »
Hi, please submit your info and I will take a hands-on look.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

vrinfo

  • Posts: 14
    • View Profile
Windows - the culprit ?
« Reply #6 on: January 15, 2008, 03:29:14 am »
Dean,

I ran into the same problems... and fought my way through them... It may not be so much Windows as the reaction of mysql and php to errors generated by mismatches between field lengths / types from client code and those in the database.

I would suggest this is a important area for testing - prior to indicating that the version is stable ! My first reaction was that the suffix d indicated development - but I can't download back versions...

Vernon