Help with G-Dating Lite

I am trying to install g-dating lite to check out the program. I am getting "invalid query" I have changed the config.inc to my database info. Any ideas?

Disregard. i got it working.

OK ...

I want to buy it


impossible to install demo......error:

dating.dating_mailbox' doesn't exist

............................................

Invalid query
Select COUNT(ID) From dating_mailbox Where accountid=84034 AND (`read`<>1 OR ISNULL(`read`))
MySQL error: Table '_dating.dating_mailbox' doesn't exist

I think for some reason the database was not installed. Try to see if you have DB installed and also see in installer directory mysql.sql file to compare tables.
For example is missing
CREATE TABLE dating_mailbox (
id int(11) NOT NULL default '0',
accountid int(11) NOT NULL default '0',
from_id int(11) default '0',
title text,
description text,
createdate date default NULL,
read tinyint(1) default NULL,
delbysender tinyint(1) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

If you cannot fix it, let us know, we will help you.

I think for some reason the database was not installed. Try to see if you have DB installed and also see in installer directory mysql.sql file to compare tables.
For example is missing ..........


Fact, result:


Error

SQL-query :

CREATE TABLE dating_mailbox(

id int( 11 ) NOT NULL default '0',
accountid int( 11 ) NOT NULL default '0',
from_id int( 11 ) default '0',
title text,
description text,
createdate date default NULL ,
READ tinyint( 1 ) default NULL ,
delbysender tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( id )
) TYPE = MYISAM

MySQL said:


#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 'READ tinyint( 1 ) default NULL ,
delbysender tinyint( 1 ) NO

Sorry, try now please

CREATE TABLE `dating_mailbox` (
`id` int(11) NOT NULL default '0',
`accountid` int(11) NOT NULL default '0',
`from_id` int(11) default '0',
`title` text,
`description` text,
`createdate` date default NULL,
`read` tinyint(1) default NULL,
`delbysender` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

home page O.k.
login erro (error.....dating_mailbox)
/admin (error)

you see:
www.megachannel.net/dating/

Sorry, try now please

table o.k.

login o.k.

admin error:

Warning: main(..//home/xxx/public_html/dating/language/en.inc.php): failed to open stream: No such file or directory in /home/xxx/public_html/dating/admin/index.php on line 20...............

On ADMIn give this error if you added PATH in config. For G-Dating is needed to be emtpy.

hour o.k.........


in admin panel,

all double:

Site Name:
Site Name:
Administrator E-mail:
Administrator E-mail:
Email Name
Email Name
Administrator name:
Administrator name:
Password
Password
Minimum age limit (0 = no age limit):
Minimum age limit (0 = no age limit):
Marital NoYes
Marital NoYes
Ads Mode: Allow AllAllow After Admin Check
Ads Mode: Allow AllAllow After Admin Check
No of ads allowed per day from one IP (0 = no limit)
No of ads allowed per day from one IP (0 = no limit)
Terms and Conditions before an account is created (empty for none) Terms and Conditions before an account is created (empty for none)
Terms and Conditions before an account is created (empty for none) Terms and Conditions before an account is created (empty for none)
Number of items to show into one page:
Number of items to show into one page:
Welcome Title on First Page
Welcome Title on First Page
Welcome Text on First Page Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.
Welcome Text on First Page Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.
Copyright
Copyright
Number of most recent registered members to show on the first page
Number of most recent registered members to show on the first page
Number of most recent ads to show on the first page
Number of most recent ads to show on the first page
Show Total Registered Users on First Page: NoYes
Show Total Registered Users on First Page: NoYes
Number of items to show into one page into admin area:
Number of items to show into one page into admin area:
Number of e-mails to be sent in one group:
Number of e-mails to be sent in one group:
Enable payments: YesNo
Enable payments: YesNo
Type of accounts (with payment): Without trial periodWith trial period
Type of accounts (with payment): Without trial periodWith trial period
Number of days of trial period
Number of days of trial period
User can Create New Ad only if is approved NoYes
User can Create New Ad only if is approved NoYes
Payment systems:
If you change this, after saving, you have to recreate all your products on payment systems! 2CheckOut
Terra Payments
Pay Pal
Payment systems:
If you change this, after saving, you have to recreate all your products on payment systems! 2CheckOut
Terra Payments
Pay Pal
Payment Currencies (only for PayPal) USD EUR GBP CAD JPY
Payment Currencies (only for PayPal) USD EUR GBP CAD JPY
Monthly payment in USD (0.00 format)
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Monthly payment in USD (0.00 format)
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Quarterly payment in USD (0.00 format)
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Quarterly payment in USD (0.00 format)
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Yearly payment in USD (0.00 format)
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Yearly payment in USD (0.00 format)
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Monthly product name
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Monthly product name
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Quarterly product name
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Quarterly product name
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Yearly product name
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Yearly product name
If you change this, after saving, you have to use the specific payments admin options to recreate the recurring products!
Number of pictures allowed
Number of pictures allowed
Maximum pictures width
Maximum pictures width
Maximum pictures height
Maximum pictures height
Maximum pictures size (KB)
Maximum pictures size (KB)

Empty dating_config and reimport again. You have imported twice and is not have unique ID. this will solve the problem.
You can find the SQL file in installer/mysql_insert.sql

how do you start the installation process on g date

please see in downloaded package the PDF documentation.