Hello Mr. Pataki!
When I received the Multi_Category mod the first thing I did was to erase the defs from its directory. All of this. Because the very purpose of the new mod is multi category mod and looking in to the SQL.pl it was supposed to create a new table of Category.Alternates. There I noticed that Alex commented
#Category Relations and followed by Category. Alternate programming. But I understood and removed all the necessary files.
Also I substituted all the files which Alex had send me thinking that they were the only ones which needed to be changed.
Then ofcourse the local host, user and passwords needed to be changed everywhere whereever it may be. So I hunted in all the files before I started enjoying the programming and ofcourse at that time I was not aware of the frustration to follow. This I found in SQL.pl only and literally copied that line from the old SQL.pl in to new one taking care of if there is an extra space at the end of the line not to be copied, as perl can may be give problems.
Then I also checked in to links.pm and saw there was nothing to be changed there.
After Alex told me to drop and create the tables, I droped all the tables from the database. Now the database is showing empty without any tables.
Quote:
Alex wrote :
1. Erase *.def in your defs folder.
2. Drop and recreate your Links SQL database.
3. Run SQL.pl
So I have droped the tables but not recreated the new database. I do not know if this is the problem, however as a novice I beleive this CANNOT be a problem. There is an existing database with or without the tables. Even in an existing anathor database I can insert an run Links SQL on it or with it so long as the links SQL and the database can romance with each other in terms of exact compatible of configurations and table names etc. However I could be wrong.
What I do not understand is why does one need to create a new links table. Thats the job of this script SQL.pl! When I try to create a new table of links it starts to ask me how many fields etc.
What I do not understand is "recreate the database". Does this mean do I have to recreate all the tables manually, with all those detailed configurations? I can do this but then I do not understand why is SQL.pl for?
Also SQL.pl give endless a compilation errors in all those lines written in my thread earlier. Line 25, 29, 60, 35, 63 etc. I cannot execute it. It does not run. If it runs there comes the question of if it can connetc to the database or not. However I do not have a lot of experience of getting perl scripts installation and execution.
So in a nutshell,
All the scripts are always uploaded in ASCII mod. All file permissions are checked. The user and the passwords are written exactly where they should be and in the suggested manner and also in the respective files. Paths are also correct in Links.pm There are no defs in the defs directory. SQL.pl is executable. No tables in the database.
Could be any problem somewhere there? or beyond?
Can there be a virus in the database? (
)
------------------
rajani