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 2012-08-24 15:49:13

charlis12my
Member
Registered: 2012-05-22
Posts: 30

upgrading my web

i try to upgrade my web ,1st i run my web with this link http://xxxxx.com/install/install.php then http://xxxxx.com/install/upgrade.php > (error message:Could not connect to the MySQL Server!)  but then i cant open my web at all, is this mean i need to install fresh installation ?

Offline

#2 2012-08-24 15:51:58

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

what is "table prefix" where to get the info?

Offline

#3 2012-08-24 16:07:50

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

Query:
Error Message: Access denied for user 'gagast_gagi'@'localhost' to database 'gagast_gagi'
Error Number: 1044

how to solve ?

Offline

#4 2012-08-24 16:57:52

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

Re: upgrading my web

Send you a email. Please check.


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

Offline

#5 2012-08-24 17:01:57

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

hi, after admin login i got such error, i didnt receive your email, my email : charlis12my@yahoo.com

Query: SELECT COUNT(*) AS total_views FROM crsvideo_history WHERE DATE_FORMAT(view_date, '%y-%m-%d') = DATE_FORMAT(NOW(), '%y-%m-%d')
Error Message: Unknown column 'view_date' in 'where clause'
Error Number: 1054

Offline

#6 2012-08-24 17:04:58

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

after upgrade all my previous version videos all gone ...can find back ?

Offline

#7 2012-08-24 18:35:02

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

Query: SELECT vh.video_id, GROUP_CONCAT(name) AS tags FROM crsvideo_history AS vh, crsvideo_tags AS t WHERE vh.user_id = 1 AND t.video_id = vh.video_id GROUP BY vh.view_date DESC LIMIT 1
Error Message: Unknown column 'vh.view_date' in 'group statement'
Error Number: 1054

Offline

#8 2012-08-25 05:25:07

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

hi,able to install the script and upgrade but i need to input all data again cause my videos all gone, the payment module i cant find it can please forward the script to me, the mobile web display is too small can help me adjust bigger like last time u adjust for me..thanks Sysm

Offline

#9 2012-08-25 07:08:48

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

Re: upgrading my web

So did something wrong during the upgrade. I'm checking. I emailed you for access.


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

Offline

#10 2012-08-25 07:41:43

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

Ok...already email u,waiting your reply..thAnks

Offline

#11 2012-08-25 09:26:57

DuttyRock
Member
Registered: 2011-11-05
Posts: 740

Re: upgrading my web

Hold up, does the upgrade erase your previous settings like templates and style.php??

Offline

#12 2012-08-25 09:55:36

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

Re: upgrading my web

Yes. It does. In the future the templates wont be changed anymore, so no need for template changes. This will slow things down a lot. The reason the template is so fast, is because there are not that many plugins/widgets and stuff that needs to be loaded.


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

Offline

#13 2012-08-25 11:17:39

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

Re: upgrading my web

You do not have anything in the video table. I dont know what you did but there is nothing in the upgrade scripts that could delete everything from the video table, unless you've run the Install, not the Upgrade.


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

Offline

#14 2012-08-25 20:33:10

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

yup,i acidetaly enter "install " so the time i enter upgrade it 's too late cause i think all data gone so i need to reinstall the script again

i already email u ,pls check the content> when i press add video the messsage below display

Query: UPDATE crsvideo SET ext = 'flv', size = , duration = 0, thumbs = 0, mobile = '0', server = 0, s3 = 0, status = 7 WHERE video_id = 1 LIMIT 1
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' duration = 0, thum' at line 3
Error Number: 1064

Offline

#15 2012-08-25 20:41:25

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

after i checking my server i still can find my old videos clip but the videos not link to latest admin panel ,is it because i run install so this cause the freshly installation so all old videos not link, can i delete the old videos clip ??

Offline

#16 2012-08-26 10:24:00

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

Re: upgrading my web

When you upgraded you've run the Installer which means your database was overwritten. You should have run the upgrade.php file not the install.php file. You have the files on your server. What i can do for you is fresh install, and then i write a small script to process all the files (so you will still have them all), but you will need to edit the title, tags, category for each video again. Is this good enough?

[NOTE]: Please always BACKUP BACKUP BACKUP before upgrading.


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

Offline

#17 2012-08-27 04:54:38

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

ok,thanks a lot..good idea.....waiting your advice again

Offline

#18 2012-08-29 20:11:11

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

hi,sysm
is everything ready ?

Offline

#19 2012-08-31 00:55:40

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

hi, sysm,
is my web ready ??

Offline

#20 2012-08-31 07:15:46

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

Re: upgrading my web

Pff...i thaught you would install it and i would make the script to load your videos. Will be done innotime.


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

Offline

#21 2012-08-31 15:11:25

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

hi, you mean i need to reinstall my web again and you will provide me the small script  ,am i right ?

Offline

#22 2012-08-31 19:11:08

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

can u check my web whether do i need to reinstall again ?

Offline

#23 2012-08-31 21:35:27

DuttyRock
Member
Registered: 2011-11-05
Posts: 740

Re: upgrading my web

charlis12my wrote:

yup,i acidetaly enter "install " so the time i enter upgrade it 's too late cause i think all data gone so i need to reinstall the script again

i already email u ,pls check the content> when i press add video the messsage below display

Query: UPDATE crsvideo SET ext = 'flv', size = , duration = 0, thumbs = 0, mobile = '0', server = 0, s3 = 0, status = 7 WHERE video_id = 1 LIMIT 1
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' duration = 0, thum' at line 3
Error Number: 1064


You got a fix to that Error Number: 1064?? im having the same issue for the last 3 days. reinstall ffmpeg and still same problem after upgrading.

Offline

#24 2012-09-01 13:01:18

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

Re: upgrading my web

FLV eg. ffmpeg is not working correctly.


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

Offline

#25 2012-09-09 07:14:15

charlis12my
Member
Registered: 2012-05-22
Posts: 30

Re: upgrading my web

Hi, sysm.. Did u receive my email, ?? Awaiting your reply for the re-installation , payment sent for installation service..

Offline

Board footer

Powered by FluxBB