Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

You are not logged in.

#1 2011-10-06 18:11:26

porntube
Member
Registered: 2010-10-05
Posts: 38

[FIXED] video delete in Admin Dashboard unter videos brings errror

Hi,

when i want delete a video in Admin Dashboard there comes an error:

Query: DELETE FROM video_feeds_imported WHERE video_id = 4 LIMIT 1
Error Message: Unknown column 'video_id' in 'where clause'
Error Number: 1054

the massage comes on a new page the video was deleted!

Regards

Offline

#2 2011-10-06 19:16:27

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [FIXED] video delete in Admin Dashboard unter videos brings errror

It is fixed already. If you want to fix from mysql console or phpmyadmin do:

ALTER TABLE `video_feeds_imported` ADD `video_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `video_feeds_imported` ADD KEY `video_id` (`video_id`);
ALTER TABLE `video_csv_imported` ADD `video_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `video_csv_imported` ADD KEY `video_id` (`video_id`);

Or drop us a email with mysql access and i'll fix.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#3 2011-10-06 20:12:11

porntube
Member
Registered: 2010-10-05
Posts: 38

Re: [FIXED] video delete in Admin Dashboard unter videos brings errror

Ahh ok thanks for this.

I bay the script on 2001-30-09 must i do more fixes ore must i use any of the upgrade scripts in the download file, ore have you a new upgrade file?

Thanks, regards

Offline

#4 2011-10-07 06:22:58

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [FIXED] video delete in Admin Dashboard unter videos brings errror

You upgraded to RC4?


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#5 2011-10-07 12:02:54

porntube
Member
Registered: 2010-10-05
Posts: 38

Re: [FIXED] video delete in Admin Dashboard unter videos brings errror

i have done a fresh install from the downloaded package on 2011-30-09 and all upgradefiles in the package give me errors "dublikate" so i think it is RC4?!
But you wrote in other Topic you have finished some fixes 2011-10-03 ore later so i dont now i have the latest version??

Offline

#6 2011-10-07 12:13:03

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546

Re: [FIXED] video delete in Admin Dashboard unter videos brings errror

Goto Admin Panel -> Video and check this Dropdown Menu

i3_check.png

If you have those entries, you use the latest Version.


sgt-halfsize-banner.jpg

Offline

#7 2011-10-07 12:33:56

porntube
Member
Registered: 2010-10-05
Posts: 38

Re: [FIXED] video delete in Admin Dashboard unter videos brings errror

Ok thanks i have the menu with this entries

Offline

#8 2011-10-11 08:14:06

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [FIXED] video delete in Admin Dashboard unter videos brings errror

Yes. There are a couple of fixes i've added after the release. Did the queries fix the problem?


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#9 2011-10-11 15:05:32

porntube
Member
Registered: 2010-10-05
Posts: 38

Re: [FIXED] video delete in Admin Dashboard unter videos brings errror

Yes the problem is solved.
Thanks

Offline

Board footer

Powered by FluxBB