Hi all, I'm new here so be gentle!

I have PHPLinks v2.1.2(I think) installed and I'm upgrading al aspects of my site. I've looked all over for a links system which is similar but keep coming back to my current install and well, I like it and it does what it should.


I downloaded PHPLinks v2.1.3.1 from SourceForge but the install didn't go as planned so I restored my old version and database.

Is there an upgrade available for me to use or should I just leave the current version installed? Can your version be installed over the top of my current?

Many thanks

Although it could be manually upgraded, currently there isn't a script to automate the process.

Are there instructions available anywhere for me to have a look at please?

Thank you.

Well.. not yet there isn't since I've never done it, but if I did, I'd certainly document the process.

I suppose the steps would be..

Download the latest version of DewNewPHPLinks and extract it.

Backup your existing installation, both the files and the database

Review the SQL file /docs/DewNewXXX.sql and you should be able to use PHPMyAdmin to create the missing tables, and add the new columns to existing tables.

Upload the new files

Make sure the .htaccess file from your /admin directory still exists ( the one that password protects your /admin directory, otherwise, likely your host's control panel allows you to password protect directories. The /admin directory can also be renamed for additional security

Refer to your back up of /includes/config.php to help you fill in the new one, mainly just the MySQL connect info, and the username/domain portions of your email address.

Copy one of the theme directories, like /themes/original/ to a new directory, like
/themes/mytheme/ and select your new theme from the admin panel's configuration page.

Likely you can just paste your old style sheet file into your new "mytheme" directory, as well as any customized graphics. You'll probably need to edit the header.php file in the theme directory to accommodate existing logo, checking both the file name and dimensions.

Keep in mind, DewNewPHPLinks uses a .htaccess file in your installation directory to tell your web server to treat the "directory" file as a PHP script. If you initially get 404 or 500 errors, please check the relevant FAQ entry http://www.dew-code.com/content/view/14/25/

I'll have a look at this properly tonight, many thanks for your reply

How do I add the numbers 1,5,453 into:

Code:

INSERT INTO `phplinks_related` VALUES (1, 5, 453);

And I cannot set ReviewerIP as NULL - it returns:

Code:

#1067 - Invalid default value for 'ReviewerIP'