Error while upgrade to 1.2.0

ivatigoal · 2014-12-11 09:18:36

Query: INSERT INTO `aspcron` VALUES (1,'video','Video Queue','video_queue',10,0,0,1), (2,'video','Video Shedule','video_shedule',10,0,0,1), (3,'video','Video Shuffle','video_shuffle',10,0,0,0), (4,'video','Video Views','video_views',1440,0,0,1), (5,'video','Video Feed','video_feed',60,0,0,1), (6,'link','Backlink Check','link_check',1440,0,0,1), (7,'photo','Photo Views','photo_views',1440,0,0,1);
Error Message: Table 'analtube_asp.aspcron' doesn't exist
Error Number: 1146

symtab · 2014-12-11 09:48:18

Ahhh....its because you use a prefix for the tables. Probably i forgot to put #__ in front of the query. Fixing.

ivatigoal · 2014-12-11 10:33:58

i have sent you the ftp access please let me know once you fix it or you can just sent me the correct upgrade php file

ivatigoal · 2014-12-11 10:50:13

even when i ocercomed the other errors i get this also so i leave up to you to o the upgrade

Query: ALTER TABLE aspmodule ADD `slugs` varchar(255) NOT NULL DEFAULT '' AFTER `description`
Error Message: Duplicate column name 'slugs'
Error Number: 1060

Last edited by ivatigoal (2014-12-11 10:50:39)

symtab · 2014-12-11 11:23:22

Thats because the upgrade was already run. I managed to run the upgrade (the problem was that i forgot to add the prefix for some queries). Please email me ssh root access. Admin login does not work, and i have to update a lot of settings.

ivatigoal · 2014-12-11 12:51:11

I did sent you all the neccessary details

thiva7 · 2014-12-11 13:10:05

Query: SELECT unique_id FROM video_csv_imported WHERE unique_id = '' LIMIT 1
Error Message:
Error Number:

symtab · 2014-12-11 14:24:57

Fixed and replied. Will get back later on checking some more options.

@thiva7: when do you get that error?

ivatigoal · 2014-12-11 14:38:33

Also related not working if sphinx is selected, video view right ad is out of place

ivatigoal · 2014-12-11 16:05:15

Ok there are many bugs need to be solved asap

1) Mobile site - videos do not play. actually the script tries to find them at media/videos/mobile but it should point to media/videos/mp4 . I tried to do the trick here http://forum.adultscriptpro.com/viewtopic.php?id=2541 but no luck
2) Mobile premium membership - when you click to upgrade your account you get a page not found
3) Mobile premium section - when you click to premium tab again you get page not found
4) Ads at video view - The video view right ad gets missplaced - if you enable one of my ads you will see what i mean
5) No results at the related videos when sphinx is enabled.
6) Upload from ftp does not work Parse error: syntax error, unexpected '$message' (T_VARIABLE) in /home/analtube/public_html/admin/modules/video/components/upload_ftp.php on line 195

symtab · 2014-12-11 16:48:45

Ahh, some of them not bugs.

1). Videos are in media/videos/mobile. There are the mobile videos located, maybe you've changed this in your install.
2). Like i told you before, the premium is not ready yet and not tested.
3). See 2.
4). Checking.
5). Checking.
6). Checking.

ivatigoal · 2014-12-11 16:56:48

I still need the number 1 sovled. I dont use seperate mp4 for mobile videos i just used according to the mentioned thread change the code so that instead of playing the /videos/mobile to play the videos/mp4 but this trick seems not to work anymore. About 2 and 3 i know you said you did not tested it but since i did i mention the errors so you wont have to look around a lot for them. I solved number 6 with the correct code from previous file

symtab · 2014-12-11 17:11:20

Checking and fixing now.

thiva7 · 2014-12-11 17:14:38

Hey Adrian

i got it when i try to add videos via Csv.

ivatigoal · 2014-12-11 19:54:46

Also rating at the mobile site does not show correctly (at the video view page and at the related videos )

symtab · 2014-12-12 07:44:02

Checking.

ivatigoal · 2014-12-12 08:52:23

Number 6 still aproblem despite there are files in the folder the script says no files in there.

symtab · 2014-12-12 09:12:34

Testing now on my box and releasing 1.2.1 with all hte reported bugs fixed.

ivatigoal · 2014-12-12 09:28:36

Please send that by mail or upload it to my server to be sure everything works as supposed

symtab · 2014-12-12 10:17:29

Once finished i will upload directly to your site.

ivatigoal · 2014-12-12 13:57:41

Adrian how much longer is it going to take? I need to upload videos

symtab · 2014-12-12 15:11:41

It depends, how many bugs i find. Maybe i will release today, or maybe tomorrow. In your case, its about ffmpeg, which is not installed correctly.

ivatigoal · 2014-12-12 15:29:15

the hoster did update ffmpeg but still not working. It was working fine before the 1.2.0 though

symtab · 2014-12-12 15:54:29

Your hosting company did not setup ffmpeg correctly:

root@vatigoal [/home/analtube/public_html/libraries/framework]# /usr/bin/ffprobe -v quiet -loglevel quiet -show_format -show_streams -print_format json '/home/analtube/public_html/tmp/uploads/33312sd.avi'
/usr/bin/ffprobe: error while loading shared libraries: libasound.so.2: cannot open shared object file: No such file or directory
root@vatigoal [/home/analtube/public_html/libraries/framework]#

Also the ffmpeg version is from GIT. Latest stable is recommended.

ivatigoal · 2014-12-12 19:09:16

Even after you fixing the problems I still can't upload videos. Please check your email for details

Adult Script Pro Community Forums

#1 2014-12-11 09:18:36

Error while upgrade to 1.2.0

#2 2014-12-11 09:48:18

Re: Error while upgrade to 1.2.0

#3 2014-12-11 10:33:58

Re: Error while upgrade to 1.2.0

#4 2014-12-11 10:50:13

Re: Error while upgrade to 1.2.0

#5 2014-12-11 11:23:22

Re: Error while upgrade to 1.2.0

#6 2014-12-11 12:51:11

Re: Error while upgrade to 1.2.0

#7 2014-12-11 13:10:05

Re: Error while upgrade to 1.2.0

#8 2014-12-11 14:24:57

Re: Error while upgrade to 1.2.0

#9 2014-12-11 14:38:33

Re: Error while upgrade to 1.2.0

#10 2014-12-11 16:05:15

Re: Error while upgrade to 1.2.0

#11 2014-12-11 16:48:45

Re: Error while upgrade to 1.2.0

#12 2014-12-11 16:56:48

Re: Error while upgrade to 1.2.0

#13 2014-12-11 17:11:20

Re: Error while upgrade to 1.2.0

#14 2014-12-11 17:14:38

Re: Error while upgrade to 1.2.0

#15 2014-12-11 19:54:46

Re: Error while upgrade to 1.2.0

#16 2014-12-12 07:44:02

Re: Error while upgrade to 1.2.0

#17 2014-12-12 08:52:23

Re: Error while upgrade to 1.2.0

#18 2014-12-12 09:12:34

Re: Error while upgrade to 1.2.0

#19 2014-12-12 09:28:36

Re: Error while upgrade to 1.2.0

#20 2014-12-12 10:17:29

Re: Error while upgrade to 1.2.0

#21 2014-12-12 13:57:41

Re: Error while upgrade to 1.2.0

#22 2014-12-12 15:11:41

Re: Error while upgrade to 1.2.0

#23 2014-12-12 15:29:15

Re: Error while upgrade to 1.2.0

#24 2014-12-12 15:54:29

Re: Error while upgrade to 1.2.0

#25 2014-12-12 19:09:16

Re: Error while upgrade to 1.2.0

Board footer