Pereiti prie turinio

Reikia pagalbos su SQL

Andrius

Sukūrė Andrius
Programuotojų kampas

 Dalintis Sekėjai 0

Rekomenduojami pranešimai

Andrius

Andrius 8

Sukurta
Sukurta

Problema yra Hyip-Listingo puslapyje, kai bandai ideti savo Hyip programa, kad listintu, galit patys uzsiregistrave pabandyti tophyips.net ir ideti, ismes error:

 

Error in SQL query. Cannot add program. Please contact with administrator. MySQL: Column count doesn't match value count at row 1

 

SQL.sql failas atrodo taip:

 

-- phpMyAdmin SQL Dump

-- version 2.6.1-pl2

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Apr 07, 2005 at 03:06 PM

-- Server version: 4.0.23

-- PHP Version: 4.3.10

--

-- Database: `hyiplife_hyip`

--

 

-- --------------------------------------------------------

 

--

-- Table structure for table `banners`

--

 

CREATE TABLE `banners` (

`id_banner` smallint(6) NOT NULL auto_increment,

`url` varchar(200) NOT NULL default '',

`link` varchar(100) NOT NULL default '',

`opis` varchar(200) NOT NULL default '',

PRIMARY KEY (`id_banner`),

UNIQUE KEY `id_banner_2` (`id_banner`),

KEY `id_banner` (`id_banner`)

) TYPE=MyISAM AUTO_INCREMENT=17 ;

 

--

-- Dumping data for table `banners`

--

 

INSERT INTO `banners` VALUES (10, 'http://www.e-topbiz.com/allbanner/e-topbiz1.gif', 'mailto:[email protected]', '$10');

 

-- --------------------------------------------------------

 

--

-- Table structure for table `ip`

--

 

CREATE TABLE `ip` (

`id_program` smallint(6) NOT NULL default '0',

`data` datetime NOT NULL default '0000-00-00 00:00:00',

`ip` varchar(11) NOT NULL default '',

`mail` varchar(100) NOT NULL default '',

KEY `id_program` (`id_program`)

) TYPE=MyISAM;

 

--

-- Dumping data for table `ip`

--

 

INSERT INTO `ip` VALUES (2, '2005-03-20 03:45:33', '217.17.84.8', '[email protected]');

 

-- --------------------------------------------------------

 

--

-- Table structure for table `news`

--

 

CREATE TABLE `news` (

`id_news` smallint(6) NOT NULL auto_increment,

`tytul` varchar(100) NOT NULL default '',

`data` datetime NOT NULL default '0000-00-00 00:00:00',

`tresc` text NOT NULL,

UNIQUE KEY `id_news` (`id_news`)

) TYPE=MyISAM AUTO_INCREMENT=3 ;

 

--

-- Dumping data for table `news`

--

 

INSERT INTO `news` VALUES (1, 'HYIPlife.com', '2005-03-24 12:37:50', 'Free premium list for five first HYIP''s.');

INSERT INTO `news` VALUES (2, 'Adding a new news', '2005-04-02 09:29:59', 'This is a test news.');

 

-- --------------------------------------------------------

 

--

-- Table structure for table `payouts`

--

 

CREATE TABLE `payouts` (

`id_payout` smallint(6) NOT NULL auto_increment,

`id_program` smallint(6) NOT NULL default '0',

`data` date NOT NULL default '0000-00-00',

`kwota` float NOT NULL default '0',

PRIMARY KEY (`id_payout`),

UNIQUE KEY `id_payout` (`id_payout`),

KEY `id_payout_2` (`id_payout`),

KEY `id_program` (`id_program`)

) TYPE=MyISAM AUTO_INCREMENT=10 ;

 

--

-- Dumping data for table `payouts`

--

 

INSERT INTO `payouts` VALUES (1, 1, '2005-03-09', 2);

INSERT INTO `payouts` VALUES (2, 1, '2005-03-09', 7);

INSERT INTO `payouts` VALUES (3, 2, '2005-03-10', 2.6);

INSERT INTO `payouts` VALUES (5, 4, '2005-03-06', 7);

INSERT INTO `payouts` VALUES (6, 6, '2005-03-24', 5.5);

INSERT INTO `payouts` VALUES (7, 6, '2005-03-25', 2.2);

INSERT INTO `payouts` VALUES (8, 4, '2005-04-04', 5);

INSERT INTO `payouts` VALUES (9, 6, '2005-04-04', 1);

 

-- --------------------------------------------------------

 

--

-- Table structure for table `programs`

--

 

CREATE TABLE `programs` (

`id_program` smallint(6) NOT NULL auto_increment,

`id_user` smallint(6) NOT NULL default '0',

`nazwa` varchar(50) NOT NULL default '',

`url` varchar(70) NOT NULL default '',

`opis` text NOT NULL,

`mail` varchar(30) NOT NULL default '',

`forum` varchar(70) NOT NULL default '',

`feedback` varchar(100) NOT NULL default '',

`telefon` varchar(20) NOT NULL default '',

`icq` varchar(30) NOT NULL default '',

`data` date NOT NULL default '0000-00-00',

`status` char(1) NOT NULL default '',

`rating` float NOT NULL default '0',

`min_payout` varchar(100) NOT NULL default '',

`min_deposit` varchar(100) NOT NULL default '',

`time_payout` varchar(150) NOT NULL default '',

`referral` varchar(20) NOT NULL default '',

`total` smallint(6) NOT NULL default '0',

`comment` text NOT NULL,

`exclusive` char(1) NOT NULL default '',

`premium` char(1) NOT NULL default '',

`blacklist` char(1) NOT NULL default '',

`egold` char(1) NOT NULL default '',

`ebullion` char(1) NOT NULL default '',

`goldmoney` char(1) NOT NULL default '',

`netpay` char(1) NOT NULL default '',

`intgold` char(1) NOT NULL default '',

`moneybookers` char(1) NOT NULL default '',

`premium_no` tinyint(4) NOT NULL default '0',

PRIMARY KEY (`id_program`),

UNIQUE KEY `id_program` (`id_program`),

KEY `id_program_2` (`id_program`),

KEY `id_user` (`id_user`)

) TYPE=MyISAM AUTO_INCREMENT=8 ;

 

--

-- Dumping data for table `programs`

--

 

INSERT INTO `programs` VALUES (4, 1, 'HYIPlife.com', 'mailto:[email protected]', 'THIS DOMAIN IS FOR SALE', '[email protected]', '', '', '', '', '2005-03-24', '4', 0.4, '10', '500', '6-12% monthly\r\n', 'n/a', 12, 'This is my comment ...', '*', '*', '', '*', '', '', '', '', '', 1);

INSERT INTO `programs` VALUES (7, 8, 'fghfgh', 'http://gfghfgh.lt', 'fghfghj', '[email protected]', '', '', '', '', '2005-04-06', '0', 0, '4', '', '1%', '', 0, '', '', '', '', '*', '', '', '', '', '', 0);

INSERT INTO `programs` VALUES (6, 1, 'HYIPsport.com', 'mailto:[email protected]', 'THIS DOMAIN IS FOR SALE - since 2004', '[email protected]', '', '', '', '', '2005-03-24', '4', 0, '5', '2000', '2.2% daily for 120 days\r\n3.6% daily for 40 days\r\n5.1-5.5% daily for 30 days', '', 9, '', '*', '*', '', '*', '', '', '', '', '', 3);

 

-- --------------------------------------------------------

 

--

-- Table structure for table `rating`

--

 

CREATE TABLE `rating` (

`id_rate` smallint(6) NOT NULL auto_increment,

`id_program` smallint(6) NOT NULL default '0',

`rate` varchar(4) NOT NULL default '0',

`data` datetime NOT NULL default '0000-00-00 00:00:00',

`mail` varchar(40) NOT NULL default '',

`komentarz` varchar(100) NOT NULL default '',

`ip` varchar(11) NOT NULL default '',

`uniqcode` varchar(150) NOT NULL default '',

PRIMARY KEY (`id_rate`),

UNIQUE KEY `id_rate` (`id_rate`),

KEY `id_rate_2` (`id_rate`),

KEY `id_program` (`id_program`)

) TYPE=MyISAM AUTO_INCREMENT=5 ;

 

--

-- Dumping data for table `rating`

--

 

INSERT INTO `rating` VALUES (1, 2, '0.1', '2005-03-20 03:45:33', '[email protected]', 'Oksdfsdfssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss', '217.17.84.8', '1111311916423d462c9af8f');

INSERT INTO `rating` VALUES (2, 4, '0.2', '2005-03-24 12:17:02', '[email protected]', '', '83.29.74.17', '');

INSERT INTO `rating` VALUES (3, 4, '0.1', '2005-04-02 09:05:25', '[email protected]', 'This is a test comment', '202.156.2.1', '');

INSERT INTO `rating` VALUES (4, 4, '0.1', '2005-04-04 05:26:12', '[email protected]', 'test', '62.15.217.7', '');

 

-- --------------------------------------------------------

 

--

-- Table structure for table `users`

--

 

CREATE TABLE `users` (

`id_user` smallint(6) NOT NULL auto_increment,

`login` varchar(15) NOT NULL default '',

`haslo` varchar(70) NOT NULL default '',

`mail` varchar(40) NOT NULL default '',

`name` varchar(100) NOT NULL default '',

`kraj` varchar(30) NOT NULL default '',

`region` varchar(50) NOT NULL default '',

`rok_urodzenia` varchar(4) NOT NULL default '0000',

`off` char(1) NOT NULL default '',

`new_mail` varchar(60) NOT NULL default '',

PRIMARY KEY (`id_user`),

UNIQUE KEY `id_user` (`id_user`),

KEY `id_user_2` (`id_user`)

) TYPE=MyISAM AUTO_INCREMENT=9 ;

 

--

-- Dumping data for table `users`

--

 

INSERT INTO `users` VALUES (1, 'admin', 't6~be69264b(', '[email protected]', 'ddd', 'Malawi', 'podkarpacie', '1988', '', 'off');

 

Taigi, kas pasakys kurioje vietoje beda gaus 2$ tiesiai i savo e-gold account.

 

Dekui

Nuoroda į pranešimą
Dalintis kituose puslapiuose

Prisijunkite prie diskusijos

Jūs galite rašyti dabar, o registruotis vėliau. Jeigu turite paskyrą, prisijunkite dabar, kad rašytumėte iš savo paskyros.

Svečias
Parašykite atsakymą...

×   Įdėta kaip raiškusis tekstas.   Atkurti formatavimą

  Only 75 emoji are allowed.

×   Nuorodos turinys įdėtas automatiškai.   Rodyti kaip įprastą nuorodą

×   Jūsų anksčiau įrašytas turinys buvo atkurtas.   Išvalyti redaktorių

×   You cannot paste images directly. Upload or insert images from URL.

Įkraunama...
×
 Dalintis
Sekėjai 0
Eiti į temų sąrašą

  • Dabar naršo   0 narių

    Nei vienas registruotas narys šiuo metu nežiūri šio puslapio.

×
×
  • Pasirinkite naujai kuriamo turinio tipą...