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-07-19 09:09:48

ful2fun.com
Member
From: Usa
Registered: 2011-09-16
Posts: 1,048
Website

Error In Uploading through FTP

Hello Friends,


I Got error in getting files uploaded through ftp this is the mysql error. can anybody let me know what this error is.

Query: UPDATE video SET ext = 'flv', duration = 540.57, thumbs = , mobile = '0', server = 0, status = 7 WHERE video_id = 153233 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 ' mobile = '0', ser' at line 4
Error Number: 1064




ful2fun.com
livesexpirates.com

Offline

#2 2012-07-20 06:24:19

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

Re: Error In Uploading through FTP

Please make sure that all folders in tmp/ and media/videos/tmb/ are chmoded to 777.


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

Offline

#3 2012-07-20 07:43:24

ful2fun.com
Member
From: Usa
Registered: 2011-09-16
Posts: 1,048
Website

Re: Error In Uploading through FTP

I Have Seen That its Correct i Researched The Code Error Its Due To Mysql Syntax Error I Am Running Mysql 5.5 So It is Not compatible With it I Will Downgrade It To 5.4...............



ful2fun.com
livesexpirates.com

Offline

#4 2012-08-31 21:50:58

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

Re: Error In Uploading through FTP

ful2fun.com wrote:

I Have Seen That its Correct i Researched The Code Error Its Due To Mysql Syntax Error I Am Running Mysql 5.5 So It is Not compatible With it I Will Downgrade It To 5.4...............



ful2fun.com
livesexpirates.com

Did 5.4 fix your issue?

Offline

#5 2012-09-01 06:25:09

ful2fun.com
Member
From: Usa
Registered: 2011-09-16
Posts: 1,048
Website

Re: Error In Uploading through FTP

ya my issue is solved i am using 5.1 and used 5.4 also its not working in 5.5

Offline

#6 2012-09-01 13:02:57

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

Re: Error In Uploading through FTP

This is not a mysql problem. Its a problem with ffmpeg or a bug in the FTP uploder.


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

Offline

#7 2012-09-01 15:14:52

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

Re: Error In Uploading through FTP

symtab wrote:

This is not a mysql problem. Its a problem with ffmpeg or a bug in the FTP uploder.

yeah. ffmpeg 0.10.4 fixed it for me. seems like the updated script needs a newer ffmpeg than the 0.6.5 yum installs.

Last edited by DuttyRock (2012-09-01 23:14:06)

Offline

#8 2012-09-01 16:19:41

ful2fun.com
Member
From: Usa
Registered: 2011-09-16
Posts: 1,048
Website

Re: Error In Uploading through FTP

I Have Latest 0.9 Or 0.9.xx And I Used In mysql 5.5 it generating problem and i tried in 5.4 with same version its start working......

Offline

Board footer

Powered by FluxBB