Find programmers and grapic design experts at ScriptLance.com
<? DEW-CODE.COM  
Dew-Code
Welcome, Guest
Please Login or Register.    Lost Password?
Problems using old phplinks database with Dew New (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Problems using old phplinks database with Dew New
#511
MUD (User)
Fresh Boarder
Posts: 17
graphgraph
User Offline Click here to see the profile of this user
Re:Problems using old phplinks dbase with Dew New 4 Months, 2 Weeks ago Karma: 0  
OK, here is a clue..

I went ahead and edited sites_main from sql error to mysql error

and this is the new error

Invalid query: Unknown column 'links.RecipURL' in 'field list'
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#513
MUD (User)
Fresh Boarder
Posts: 17
graphgraph
User Offline Click here to see the profile of this user
Re:Problems using old phplinks dbase with Dew New 4 Months, 2 Weeks ago Karma: 0  
You are perobably wondering why I changed from an older but working version to Dew New. I had an incompatability issue with PHP on a new host. So I installed yours from Fantastico and had the same problem. Global Variables turned off. I found the famous edit to directory(php) on your forum and did that. It started working. I edited /include/config to point at my database, which also had 9 tables like the one yours had. I copied the password from the old config file on the other version (now gone unfortunately)because I did get a password error while browzing.

Now everything seems to work except adding and editing sites.

That's why I made the small donation
 
Report to moderator   Logged Logged  
 
Last Edit: 2008/08/26 14:47 By MUD.
  The administrator has disabled public write access.
#514
Dewed (Moderator)
Moderator
Posts: 250
graph
User Offline Click here to see the profile of this user
Dew-Code.com
Re:Problems using old phplinks dbase with Dew New 4 Months, 2 Weeks ago Karma: 7  
ok, so both your temp table and links table lack that column ..

you can add them with the following mysql queries,, again pasting them into phpmyadmin

Code:

ALTER TABLE `phplinks_links` ADD `RecipURL` VARCHAR( 255 ) AFTER `SiteURL` ; ALTER TABLE `phplinks_temp` ADD `RecipURL` VARCHAR( 255 ) AFTER `SiteURL` ;
Again you may need to correct the table names to match what you have
 
Report to moderator   Logged Logged  
 
Nothing to it but to Dew it !
Dew-Code.com
  The administrator has disabled public write access.
#515
MUD (User)
Fresh Boarder
Posts: 17
graphgraph
User Offline Click here to see the profile of this user
Re:Problems using old phplinks dbase with Dew New 4 Months, 2 Weeks ago Karma: 0  
Invalid query: Unknown column 'links.featured' in 'field list'

There's probably going to be a few more like that and then it might work..
 
Report to moderator   Logged Logged  
 
Last Edit: 2008/08/26 15:14 By MUD.
  The administrator has disabled public write access.
#516
Dewed (Moderator)
Moderator
Posts: 250
graph
User Offline Click here to see the profile of this user
Dew-Code.com
Re:Problems using old phplinks dbase with Dew New 4 Months, 2 Weeks ago Karma: 7  
Ok,...

Code:

ALTER TABLE `phplinks_links` ADD `featured` set('0','1') NOT NULL default '0' AFTER `Description` ; ALTER TABLE `phplinks_temp` ADD `featured` set('0','1') NOT NULL default '0' AFTER `Description` ;
 
Report to moderator   Logged Logged  
 
Last Edit: 2008/08/26 15:14 By Dewed.
 
Nothing to it but to Dew it !
Dew-Code.com
  The administrator has disabled public write access.
#517
MUD (User)
Fresh Boarder
Posts: 17
graphgraph
User Offline Click here to see the profile of this user
Re:Problems using old phplinks dbase with Dew New 4 Months, 2 Weeks ago Karma: 0  
It made a smiley...I think you need to use the code button lol
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Newsflash

Sign up for PayPal and start accepting credit card payments instantly.
Copyright Dew-Code 2008