|
 |
|
| Author |
Topic: Cannot Search During Table Check/Repairs |
|
 |
gurudood |
Member
|
  
|
During the rebuilding process , the first step is for it to check and repair the tables. During this process, noone can use my search until it is done , which generally takes 1-2 minutes. BUT it is important that the tables are checked and repaired so they dont screw up again on me.
Is there any way to fix this?
Also I try to implement the following line in the SQL Tool:
UPDATE links SET thumbnail2_cust = 'http://mywebsite.com/anyphoto.gif' WHERE thumbnail2_cust IS NULL
It works for some of my listings but hardly any? Any idea why maybe?
Any tips or ideas to find out why it is not replaceing the listings with no photos (null) to photos? Any simple way to double check the value is null for them all? And if they are NULL why wont they change to the url I provide pointed to a picture?
GuruDood |
Total Posts: 95 | Joined:
Jul 28, 2003 - 12:58am | IP
Logged
|
|
FocalMedia Team
Moderator
|
|
You can turn off the 'check and repairing' of tables by opening generate.cgi with a unix compatible text editor like Textpad
Inside near the top of generate.cgi there is a line:
$repair_tables = "Y"; ### Y/N
change it to:
$repair_tables = "N"; ### Y/N
You can then check & repair tables manually (once a week for example) by following the instructions here:
http://www.focalmedia.net/pseekmanual/pseek8.html#8_9
For the SQL query also try:
UPDATE links SET thumbnail2_cust = 'http://mywebsite.com/anyphoto.gif' WHERE thumbnail2_cust = ''
Gerrit
|
Total Posts: 1453 | Joined:
Jul 27, 2002 - 4:28am | IP
Logged
|
|
|
Forum Legend |
|
New Member
|
|
Reply
to topic |
|
More
than 50 posts | Member
|
|
Reply
to topic with quoted message |
|
More
than 100 posts | Full Member
|
|
Edit
Message |
|
More
than 150 posts | Advanced Member
|
|
View
profile |
|
More
than 200 posts | Advanced Member |
|
Email
member |
|
|
