[Meghwar]

Originally Posted by Meghwar

I was mistaken delete the DownloadsII tabels, I load them back from my BackUp daily DB I see every thing Ok , when I click Download I get the Msg bellow!!!

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

SELECT time
FROM dl_downloads
WHERE `userid`=1
AND `clientip`='21.332.222.133'
ORDER BY `time` DESC LIMIT 0,1;

MySQL Error : Unknown column 'clientip' in 'where clause'
Error Number : 1054
Date : Wednesday, January 30th 2008 @ 02:07:52 PM
Script : http://www.*********.org/forum/downloa...d=553&act=down
Referrer : http://www.***********.org/forum/dow...do=file&id=553
IP Address : **********
Username : Meghwar
Classname : vB_Database
MySQL Version : 5.0.45-log

thanx all SOLVED

i was missing :

MySQL Error : Unknown column 'clientip' in 'where clause'

Solution: I drop the table dl_downloads and input the :

--
-- Table structure for table `dl_downloads`
--

DROP TABLE IF EXISTS `dl_downloads`;
CREATE TABLE `dl_downloads` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`fileid` int(10) unsigned NOT NULL,
`user` varchar(20) NOT NULL,
`file` varchar(20) NOT NULL,
`time` int(10) unsigned NOT NULL,
`filesize` int(10) unsigned NOT NULL,
`clientip` varchar(16) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=403908 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dl_downloads`
--

Solved