ERROR upgrade to v1

mario2000 · 2012-08-12 07:43:26

I have this mysql errorr in my videos

Query: INSERT INTO wmvideo_history SET video_id = 1485, user_id = 1, ip = 1388717186, view_date = '2012-08-12 09:35:38'
Error Message: Unknown column 'view_date' in 'field list'
Error Number: 1054

symtab · 2012-08-12 12:58:55

This means the upgrade was not run correctly. Please run the below queries in mysql (only the queries, not the php code itself):

    $db->query("ALTER TABLE `#__video_history` DROP COLUMN `view_date`;");
    $db->query("ALTER TABLE `#__video_history` DROP COLUMN `status`;");
    $db->query("ALTER TABLE `#__video_history` DROP KEY `ip`;");
    $db->query("ALTER TABLE `#__video_history` ADD `view_time` int(11) NOT NULL default '0'");
    $db->query("ALTER TABLE `#__video_history` ADD KEY `view_time` (`view_time`);");

mario2000 · 2012-08-12 14:29:58

I have correct the code to:
-------------------
ALTER TABLE `wmvideo_history` DROP COLUMN `view_date`;
ALTER TABLE `wmvideo_history` DROP COLUMN `status`;
ALTER TABLE `wmvideo_history` DROP KEY `ip`;
ALTER TABLE `wmvideo_history` ADD `view_time` int(11) NOT NULL default '0'
ALTER TABLE `wmvideo_history` ADD KEY `view_time` (`view_time`);
------------------

The error is now:

Error
consulta SQL:

ALTER TABLE `wmvideo_history` DROP COLUMN `view_date` ;

MySQL ha dicho:

#1091 - Can't DROP 'view_date'; check that column/key exists

mario2000 · 2012-08-12 14:36:14

The video_history table lok like this:

   video_id user_id ip view_time
   Editar    Editar en línea    Copiar    Borrar 1 1 3563170928 0
   Editar    Editar en línea    Copiar    Borrar 1 1 3563170928 0
   Editar    Editar en línea    Copiar    Borrar 1 1 3563170928 0
   Editar    Editar en línea    Copiar    Borrar 2 1 1429722747 0
   Editar    Editar en línea    Copiar    Borrar 2 0 1123633328 0
   Editar    Editar en línea    Copiar    Borrar 1 0 2927750557 0

Last edited by mario2000 (2012-08-12 14:37:02)

mario2000 · 2012-08-12 14:54:02

After repair the db from - admin - tools- repair.. , i gest have the error in the premium videos.

http://brutal5.com/premium/1459/muy-bue … -zoofilia/
Query: INSERT INTO wmvideo_history SET video_id = 1459, user_id = 1, ip = 1388717186, view_date = '2012-08-12 04:42:37'
Error Message: Unknown column 'view_date' in 'field list'
Error Number: 1054

In the normal videos sems to work well:
http://brutal5.com/1507/amateurs2/

Also, if i change an video from premium to normal video, work, (without /premium/), so the problem sems to bee in the premium module.

Last edited by mario2000 (2012-08-12 14:55:23)

mmpo · 2012-08-12 21:53:54

Zoofilia????

Reallllllyyyyy?????

WHAT THE FUCK IS WRONG WITH YOU???????????????????

symtab · 2012-08-13 05:36:25

The premium module is not completly finished and it will not work. We will test the premium module again this week and then i will send you the module (i think i told you this in the email i sent you).

mario2000 · 2012-08-13 08:35:31

symtab wrote:

The premium module is not completly finished and it will not work. We will test the premium module again this week and then i will send you the module (i think i told you this in the email i sent you).

I understanding that it does not work paypal, not can I not see the videos.
I will wait
Thank you.

mario2000 · 2012-08-13 08:37:57

mmpo wrote:

Zoofilia????
Reallllllyyyyy?????
WHAT THE FUCK IS WRONG WITH YOU???????????????????

WHAT THE FUCK IS WRONG WITH YOU?
is legal conent in Spain

ful2fun.com · 2012-08-13 09:09:43

@mario2000.... he thinks he only doing legal business and all others are working illegally and other does not know anything ..................

Adult Script Pro Community Forums

#1 2012-08-12 07:43:26

ERROR upgrade to v1

#2 2012-08-12 12:58:55

Re: ERROR upgrade to v1

#3 2012-08-12 14:29:58

Re: ERROR upgrade to v1

#4 2012-08-12 14:36:14

Re: ERROR upgrade to v1

#5 2012-08-12 14:54:02

Re: ERROR upgrade to v1

#6 2012-08-12 21:53:54

Re: ERROR upgrade to v1

#7 2012-08-13 05:36:25

Re: ERROR upgrade to v1

#8 2012-08-13 08:35:31

Re: ERROR upgrade to v1

#9 2012-08-13 08:37:57

Re: ERROR upgrade to v1

#10 2012-08-13 09:09:43

Re: ERROR upgrade to v1

Board footer