biow0lf / evedev-kb

Automatically exported from code.google.com/p/evedev-kb
1 stars 0 forks source link

Cant create new campaign #144

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.going admin campaign add
2.fill form click save
3.get next error
WARNING [512] SQL error (Column count doesn't match value count at row 1
Error on line 402 in file 
/home/users1/j/joysi/domains/u-ds.ru/kb/common/includes/class.dbcachedquery.php
PHP 5.2.13 (Linux), EDK 3.1.0 (Tyrannis)
File: kb/common/includes/class.dbcachedquery.php, line: 402, function: 
trigger_error
File: kb/common/includes/class.contract.php, line: 288, class: DBCachedQuery, 
function: execute
File: kb/common/admin/admin_cc.php, line: 279, class: Contract, function: add
File: kb/common/index.php, line: 307, function: include
File: kb/index.php, line: 21, function: include

insert into kb3_contracts values ( null, 'test', 'httpu-dsrukb', 1, '2010-09-02 
00:00:00', '2010-09-05 23:59:59', 'gg' )
Query failed. Column count doesn't match value count at row 1

3.1.0 (Tyrannis) rev Dev 865
PHP version: 5.2.13 
 MYSQL version: 5

What version of the board are you using? e.g. 3.0.5 or 3.1 revision 644
What version of PHP and MySQL does the board run on?

What is the url of a page where the error occurs or has occurred?
http://u-ds.ru/kb/?a=admin_cc&ctr_id=&op=add&type=campaign
Please provide any additional information below.
tried to replase with r781 as was adviced in issue 125 still no luck please 
advice

Original issue reported on code.google.com by kotsum...@gmail.com on 2 Sep 2010 at 9:23

GoogleCodeExporter commented 9 years ago
What columns do you have in your kb3_contracts table? Did you have any errors 
during the upgrade/install of 3.1?

Original comment by mastergamer0168@gmail.com on 2 Sep 2010 at 11:56

GoogleCodeExporter commented 9 years ago
yes there was some errors on tables import but i rerun it. and how can i view 
that table content? mysql has access only from localhost and hosting doesnt 
give ssh or any console to it. only crapy web interface

Original comment by kotsum...@gmail.com on 2 Sep 2010 at 1:04

GoogleCodeExporter commented 9 years ago
Is there no phpMyAdmin or some other DB management package as part of the web 
interface? If not, you could try setting up phpMyAdmin or something else to 
view the database with.

Original comment by mastergamer0168@gmail.com on 2 Sep 2010 at 1:24

GoogleCodeExporter commented 9 years ago
ok i have found access to that base. so as i see i have 
ctr_id  int(11)         No  None auto_increment                          
 ctr_name   char(128)   utf8_general_ci     No  None                                    ctr_site    char(64)    utf8_general_ci     No  None                                 
 ctr_campaign   int(6)          No  0                                
    ctr_started datetime            No  0000-00-00 00:00:00                              
    ctr_ended   datetime            Yes 0000-00-00 00:00:00

Original comment by kotsum...@gmail.com on 2 Sep 2010 at 1:40

GoogleCodeExporter commented 9 years ago
As I suspected, one of the updates didn't run correctly. Go to 
[boardURL]/update/index.php?level=015&do=force

That should re-run the update to add the column you're missing.

Original comment by mastergamer0168@gmail.com on 2 Sep 2010 at 1:46

GoogleCodeExporter commented 9 years ago
I think that should be http://u-ds.ru/kb/update/?do=force&level=014 since 015 
adds the comment column.

Original comment by kovellia on 2 Sep 2010 at 1:50

GoogleCodeExporter commented 9 years ago
Oops, yeah, what he said :p

Original comment by mastergamer0168@gmail.com on 2 Sep 2010 at 1:53

GoogleCodeExporter commented 9 years ago
thats did the trick!!! thanks comrades!!

Original comment by kotsum...@gmail.com on 2 Sep 2010 at 4:46

GoogleCodeExporter commented 9 years ago

Original comment by mastergamer0168@gmail.com on 2 Sep 2010 at 5:00