|
 |
|
| Author |
Topic: Add New Keys/Fields |
|
misstchiph
New Member
|
  
|
I wondered if the methods for adding new keys/fields has changed since the posted documentation. Is there yet or is there planned a method to add keys/fields that is not destructive to the categories and links?
If so or if not, please outline the exact procedure that must be done to add new keys/fields, assuming that I cannot use the database backup feature but must use a third party backup program.
Thanks,
Miss Tchiph
|
Total Posts: 46 | Joined:
Mar 11, 2003 - 2:47am | IP
Logged
|
|
 |
Rik |
Advanced Member
|
|
Hi,
You can backup your data via PSeek in the Plugins Ara.
You can create more keyfields without losing your data by going through the procedure you used when you first created your keyfields.
Just do the same again, add additional keyfields and when your done 'restore' the backed up data again by going to 'Plugins'.
Hope that helps
Regards
Rik |
Total Posts: 528 | Joined:
Apr 2, 2002 - 7:21am | IP
Logged
|
|
misstchiph
New Member
|
|
Thanks Rick,
Last time I tried to use the built in database backup it did not work. It's been awhile, so I forget what went wrong. Maybe I'll try it again before using the third party program.
Also I remember having some problems after restoring the data subsequent to adding the new keys.
I'll try again and let you know what happens.
Thanks,
Miss Tchiph
|
Total Posts: 46 | Joined:
Mar 11, 2003 - 2:47am | IP
Logged
|
|
 |
nsatguy |
Member
|
|
Quote:
Also I remember having some problems after restoring the data subsequent to adding the new keys.
|
|
I'm on the same boat as you miss... I have to add more fields but am totally paranoid about losing any data. Just can't get up the nerve to do this yet but would greatly appreciate if you can let me know how you make out.
- Bruce |
Total Posts: 72 | Joined:
Mar 13, 2003 - 7:01pm | IP
Logged
|
|
 |
nsatguy |
Member
|
|
Quote:
I'm on the same boat as you miss... I have to add more fields but am totally paranoid about losing any data. Just can't get up the nerve to do this yet but would greatly appreciate if you can let me know how you make out.
|
|
Dam, should've listened to myself. I followed the directions for adding new fields after backing up the database to a "T" and well here is what happened.
1. Used mySQL dump method for backup... backup was successful.
2. Ran setup.cgi and added extra fields successfully.
3. Restored database from backup and "BANG" !!!!
Even though PSEEK said I had x number of listings and directories to restore, after it did its thing there wasn't a listing or directory to be found.
Thank god I had backed up my database using my host's backup tool. After restoring the database using this tool I was able to get back all my directories and listings.
Now for the heart attack part... all the extra fields are available in the directory manager but there is "0's" in all the fields when viewing the listings using the control panel. Also, if I attempt to edit a listing, all the extra fields are blank and no matter what I do, when you attempt to save your changes you get this error from PSEEK:
... continued in next post |
Total Posts: 72 | Joined:
Mar 13, 2003 - 7:01pm | IP
Logged
|
|
| |
nsatguy |
Member
|
|
Focal must have a limit on characters per post... cont'd from previous...
Edit Listing Error:
Quote:
Content-type: text/html
Software error:
SQL Syntax Error: Unknown column 'image2_cust' in 'field list' - From: UPDATE links SET title = ?,
description = ?,
keywords = ?,
url = ?,
image = ?,
imagelinked = ?,
name = ?,
email = ?,
rating = ?,
votes = ?,
hits = ?,
premium = ?,
lnkpassword = ?,
subs_expire = ?
, image_cust = ?, brochure_cust = ?, image2_cust = ?, image3_cust = ?, image4_cust = ?, enhanced_cust = ?, lmap_cust = ?, amap_cust = ?
WHERE lnkid = ? at unlock.cgi line 226.
|
|
And when you attempt to do a search and PSEEK uses the search.cgi script this is the error you get:
Quote:
Software error:
syntax error at search.cgi line 65, near "= ."
Execution of search.cgi aborted due to compilation errors.
|
|
However, when PSEEK uses the search2.cgi script it works. If anyone has any ideas about what is going on or how to resolve it, I WOULD BE ETERNALLY GRATEFUL...
Totally screwed,
- Bruce |
Total Posts: 72 | Joined:
Mar 13, 2003 - 7:01pm | IP
Logged
|
|
| |
Rik |
Advanced Member
|
|
Hi,
I use PS backup and restore around twice a week without any problems.
When needing to add new keyfields I run setup create new keyfields and then restore dat using PSeek.....no problems.
I found using the dump feature in MySQL did cause problems.
Regards
Rik |
Total Posts: 528 | Joined:
Apr 2, 2002 - 7:21am | IP
Logged
|
|
misstchiph
New Member
|
|
Bruce, the messages you have described sound very familiar. I haven't gotten up the nerve to try it again myself, but must do as I am waiting to add links until I can get the thing working. I find it worth it to pay for hosting until everything can be up and running nicely, then add links.
Also it won't be much until the upcoming multiple editor plugin. The whole purpose of my directory is to allow editors to flourish, with editorial poetic license and pride in their work.
I need to start adding links soon, after finishing redesign of all these templates, so before that I hope to get the desired keys/fields installed with search and edit continuing to work at the same time.
Where there's a will, there's a way 
|
Total Posts: 46 | Joined:
Mar 11, 2003 - 2:47am | IP
Logged
|
|
misstchiph
New Member
|
|
Rick, could you please explain more about using the MySQL dump feature as opposed to not using it? I remember something about one way not working on my server and the other working. That's all I remember about the choices to make on how to do the backup.
Thanks,
Miss Tchiph
|
Total Posts: 46 | Joined:
Mar 11, 2003 - 2:47am | IP
Logged
|
|
FocalMedia Team
Moderator
|
|
Some notes that would prevent the problems as explained above.
The backup and restore utility is FAIL-SAFE. So, no matter what you do to your database, you can get PowerSeek in it's original state once something has gone wrong when adding extra fields/keys. Before adding extra fields/keys make a backup as explained in the manual.
BACKUP INSTRUCTIONS
As explained here:
http://www.focalmedia.net/pseekmanual/pseek9.html#9.6.1
Step 1: Go to the Control Panel > Plug-Ins > Data Backups
Step 2: Click the 'Backup Database' link.
Step 3: After clicking the 'Backup Database' link, the PowerSeek backup script will back up all your database tables. All data in the database PowerSeek uses will be exported to your 'data' directory and placed inside a subdirectory called dbbackup. The 'data' directory is explained in the installation instructions of PowerSeek.
Step 4: Now transfer the entire contents of the 'data' directory to your hard drive so that you can back it up on a CD or some other suitable medium.
Do Step 4 - It is very important!
RESTORATION - IF SOMETHING WENT WRONG
Let's say you changed keys/fields and something goes wrong. I'll explain below why things go wrong later.
Step 1: Transfer the contents of the 'data' directory that you backed up prevously to your 'data' directory.
It is very important that you do the step above. Remember that the PowerSeek data files tells PowerSeek how your database looks like when you have altered it by adding extra fields/keys.
Step 2: Assign the permission setting of 777 to all the files that you transferred to your 'data' directory.
Step 3: Go to the Control Panel > Plug-Ins > Data Backups
Step 4: Click on the 'Restore Database Backup' link.
================================
Real-time table changes may be implemented for telnet/ssh in future - it won't be available to be done in the browser. The reason for this is because with large search engines the changes can take hours and the browser will not wait for hours while MySQL alters the table.
The following entry in the knowledge base has also been updated to include additional information (it explains how to add extra fields/keys)
http://www.focalmedia.net/cgi-bin/knowledge/linfo.cgi?id=35
======================
I would strongly discourage the use of third party backup utilities for backups. They can be unreliable and you can loose your links this way.
Also, you cannot backup the database with a third party utility, change fields and restore the data with the third party backup utillity. The PowerSeek backup utillity exports and imports data in a special way so that new fields/keys can be recognized by PowerSeek.
======================
Bruce,
It sounds like PowerSeek's keys.dat file is not in sync with the fields/keys you presently have. To fix the problem send me the structure of your database (you can get it in myPHPadmin) and your keys.dat file (it is situated in your 'data' directory) and I will edit it by hand so that the keys.dat file has the correct info on how your database looks like inside.
When adding extra fields/keys in future - make a complete backup so that you can get PowerSeek with your links back to it's original state if something goes wrong.
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 |
|
|
