Dating Website Support Forum - Webscribble

if there are tables missing your script cannot communicate with certain areas of the database...

you need to export (backup) your entire database

then erase the database and create a new (empty one)

then install the webdate version and with plugins you wish to install upload plug ins after the main script,, then check off all the plug ins when running the install http://yoursite.com/install.php

after the script is up and running with the new database you can then go to phpmyadmin and import your old database... now all the required tables and fields should exist.

Hope you understand what I am getting at

also you might want to try and download a fresh copy of the install script from webscribbles site as the files do become corrupted on download at times.

Code: Select all

[root@xxxxx httpdocs]# mysql xxxxx < xxxxx.sql   
ERROR 1050 (42S01) at line 19: Table 'dt_address_book' already exists

Code: Select all

[root@xxxxx httpdocs]# mysql -u xxxxxx -p xxxxx < xxxxx.sql
Enter password:
[root@xxxxx httpdocs]#

I have restarted MySQL, but there are some problem queries that keep backlogging:
explain SELECT *, p.id, p.gender, p.name FROM (dt_profile p, dt_members m, dt_privacy pr) JOIN dt_photos f ON p.member_id = f.member_id WHERE (p.status='1' AND (pr.featured_yn IS NULL OR pr.featured_yn='') AND pr.member_id=m.id AND p.member_id=m.id AND p.gender='Female') ORDER BY p.lastlogin DESC LIMIT 1;
+----+-------------+-------+------+---------------+------+---------+------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+------+------+----------------------------------------------+
| 1 | SIMPLE | p | ALL | NULL | NULL | NULL | NULL | 648 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | m | ALL | NULL | NULL | NULL | NULL | 761 | Using where |
| 1 | SIMPLE | pr | ALL | NULL | NULL | NULL | NULL | 656 | Using where |
| 1 | SIMPLE | f | ALL | NULL | NULL | NULL | NULL | 444 | Using where |
+----+-------------+-------+------+---------------+------+---------+------+------+----------------------------------------------+
4 rows in set (0.00 sec)

So that query is having to sort through 143630433792 rows for the xxxxx.com site. That query needs to be optimized or it will likely cause slow performance for MySQL and sites reliant upon them.

Code: Select all

<?
   
   parseVariables("templates/index.html");
?>