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 2014-07-29 18:05:19

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

[FIXED IN 1.0.11] Sql Error - Admin upload

When i upload a Video in Admin CP i get this Error:

Query: UDAPTE video_sponsors SET total_videos = total_videos+1 WHERE sponsor_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 'UDAPTE video_sponsors SET total_videos = total_videos+1' at line 1
Error Number: 1064

index.php?q=video/upload -> select a videosponsor -> Upload Method: URL

Nginx 1.6.0
PHP Version 5.5.15-1
MySQL-Client+Server-Version: 5.6.19

Last edited by Coscast (2014-07-29 19:50:16)


sgt-halfsize-banner.jpg

Offline

#2 2014-07-29 21:05:58

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

Re: [FIXED IN 1.0.11] Sql Error - Admin upload

Ahh...its a type. Edit admin/modules/video/components/upload.php and find:

UDAPTE

replace with:

UPDATE

Will also include this fix in 1.0.11.


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

Offline

#3 2014-07-29 21:30:43

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

Re: [FIXED IN 1.0.11] Sql Error - Admin upload

I should have seen that. Thanks smile


sgt-halfsize-banner.jpg

Offline

#4 2014-07-30 06:52:38

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

Re: [FIXED IN 1.0.11] Sql Error - Admin upload

Yeah...i also should have seen that :-))))))))))))) Thank you also.


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

Offline

#5 2014-07-31 07:26:45

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

Re: [FIXED IN 1.0.11] Sql Error - Admin upload

Fixed in 1.0.11.


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

Offline

Board footer

Powered by FluxBB