We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

i have this error while adding a youtube video | Forum

Onur
Onur Dec 16 '20

[Thu Dec 17 0:29:43 2020] [ow_core_log] [Exception] Message: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'type":"link","description":"Music video by Irini Merkouri performing Pou Na Fant' at line 1 File: /var/www/vhosts/ilkok.com/httpdocs/ow_core/database.php Line:723 Trace: [#0 /var/www/vhosts/ilkok.com/httpdocs/ow_core/database.php(723): PDOStatement->execute() | #1 /var/www/vhosts/ilkok.com/httpdocs/ow_core/database.php(344): OW_Database->execute('SELECT * FROM o...', NULL) | #2 /var/www/vhosts/ilkok.com/httpdocs/ow_plugins/newsfeed/bol/like_dao.php(172): OW_Database->queryForObjectList('SELECT * FROM o...', 'NEWSFEED_BOL_Li...') | #3 /var/www/vhosts/ilkok.com/httpdocs/ow_plugins/newsfeed/bol/service.php(519): NEWSFEED_BOL_LikeDao->findByEntityList(Array) | #4 /var/www/vhosts/ilkok.com/httpdocs/ow_plugins/newsfeed/components/feed_list.php(101): NEWSFEED_BOL_Service->findLikesByEntityList(Array) | #5 [internal function]: NEWSFEED_CMP_FeedList->__construct(Array, Array) | #6 /var/www/vhosts/ilkok.com/httpdocs/ow_core/ow.php(492): ReflectionClass->newInstanceArgs(Array) | #7 /var/www/vhosts/ilkok.com/httpdocs/ow_core/ow.php(456): OW::getClassInstanceArray('NEWSFEED_CMP_Fe...', Array) | #8 /var/www/vhosts/ilkok.com/httpdocs/ow_plugins/newsfeed/components/feed.php(230): OW::getClassInstance('NEWSFEED_CMP_Fe...', Array, Array) | #9 /var/www/vhosts/ilkok.com/httpdocs/ow_plugins/newsfeed/components/feed.php(255): NEWSFEED_CMP_Feed->createFeedList(Array, Array) | #10 /var/www/vhosts/ilkok.com/httpdocs/ow_core/renderable.php(124): NEWSFEED_CMP_Feed->render() | #11 /var/www/vhosts/ilkok.com/httpdocs/ow_core/view.php(183): OW_Renderable->onRender() | #12 /var/www/vhosts/ilkok.com/httpdocs/ow_core/component.php(80): OW_View->render() | #13 /var/www/vhosts/ilkok.com/httpdocs/ow_core/renderable.php(124): OW_Component->render() | #14 /var/www/vhosts/ilkok.com/httpdocs/ow_core/view.php(183): OW_Renderable->onRender() | #15 /var/www/vhosts/ilkok.com/httpdocs/ow_core/component.php(80): OW_View->render() | #16 /var/www/vhosts/ilkok.com/httpdocs/ow_system_plugins/base/components/drag_and_drop_item.php(332): OW_Component->render() | #17 /var/www/vhosts/ilkok.com/httpdocs/ow_system_plugins/base/components/drag_and_drop_item.php(317): BASE_CMP_DragAndDropItem->render() | #18 /var/www/vhosts/ilkok.com/httpdocs/ow_system_plugins/base/components/drag_and_drop_frontend_panel.php(110): BASE_CMP_DragAndDropItem->renderView() | #19 /var/www/vhosts/ilkok.com/httpdocs/ow_smarty/template_c/0032f38d81f6ba59192ab1f17cf7af1bce792eb3_0.file.drag_and_drop_index.html.php(152): BASE_CMP_DragAndDropFrontendPanel->tplComponent(Array, Object(Smarty_Internal_Template)) | #20 /var/www/vhosts/ilkok.com/httpdocs/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(122): content_5fda863f868b35_07451466(Object(Smarty_Internal_Template)) | #21 /var/www/vhosts/ilkok.com/httpdocs/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(199): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template)) | #22 /var/www/vhosts/ilkok.com/httpdocs/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(159): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template)) | #23 /var/www/vhosts/ilkok.com/httpdocs/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(191): Smarty_Internal_Template->render(false, 0) | #24 /var/www/vhosts/ilkok.com/httpdocs/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(94): Smarty_Internal_TemplateBase->_execute('/var/www/vhosts...', NULL, NULL, NULL, 0) | #25 /var/www/vhosts/ilkok.com/httpdocs/ow_core/view_renderer.php(80): Smarty_Internal_TemplateBase->fetch('/var/www/vhosts...') | #26 /var/www/vhosts/ilkok.com/httpdocs/ow_core/view.php(187): OW_ViewRenderer->renderTemplate('/var/www/vhosts...') | #27 /var/www/vhosts/ilkok.com/httpdocs/ow_core/component.php(80): OW_View->render() | #28 /var/www/vhosts/ilkok.com/httpdocs/ow_core/renderable.php(124): OW_Component->render() | #29 /var/www/vhosts/ilkok.com/httpdocs/ow_core/view.php(183): OW_Renderable->onRender() | #30 /var/www/vhosts/ilkok.com/httpdocs/ow_system_plugins/base/controllers/component_panel.php(56): OW_View->render() | #31 /var/www/vhosts/ilkok.com/httpdocs/ow_core/request_handler.php(258): BASE_CTRL_ComponentPanel->render() | #32 /var/www/vhosts/ilkok.com/httpdocs/ow_core/request_handler.php(226): OW_RequestHandler->processControllerAction(Object(ReflectionMethod), Object(BASE_CTRL_ComponentPanel)) | #33 /var/www/vhosts/ilkok.com/httpdocs/ow_core/application.php(346): OW_RequestHandler->dispatch() | #34 /var/www/vhosts/ilkok.com/httpdocs/index.php(76): OW_Application->handleRequest() | #35 {main}]



why i have this error?

Onur
Onur Dec 16 '20
i am trying to add videos on youtube videos are no longer embedded on the my website
Onur
Onur Dec 16 '20


not more working videos plugin

Marcus
Marcus Dec 17 '20
Hi folks this forum is deserted. lol 

The problem is in the ow oembed url which is http and youtube requires https this means all http calls are denied. 
Patricia Zorrilla Leader
Patricia Zorrilla Dec 17 '20

Solved!

Download the patch for free:

https://owspain.com/store/productview/137

Onur
Onur Dec 17 '20

Quote from Patricia Zorrilla

Solved!

Download the patch for free:

https://owspain.com/store/productview/137

thank your for answer. 


i am waiting to pending approval for my account on owspain.com

Patricia Zorrilla Leader
Patricia Zorrilla Dec 17 '20

You are already approved, I use manual approval to avoid spam.

Sorry for the delay!


Onur
Onur Dec 17 '20

Quote from Patricia Zorrilla

You are already approved, I use manual approval to avoid spam.

Sorry for the delay!


thank you. spam is everywhere :) 
David
David Dec 19 '20
Wont allow me to download.
Patricia Zorrilla Leader
Patricia Zorrilla Dec 19 '20

Try again, please.

I had established to review the testimonials, but I do not see that any are wrong, incorrect, disrespectful, include spam or anything similar.

I have modified the settings and the reviews are self-approved and posted immediately.

Please, publish your suggestions to obtain a site to our liking and convenience!

David
David Dec 19 '20
I love the site! I sincerely do LOVE it. I think it's a great thing you're doing!
dave Team
dave Jan 13
glad you got it sorted, and marcus its not abandoned, its just slow..
Edward D. Clemmer

I am using PDO and PHP.

My code:

$vals = array( ':from' => $email, ':to' => $recipient, ':name' => $name, ':subject' => $subject, ':message' = >$message ); print_r($vals); try { $pdo = new PDOConfig(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT * FROM messages WHERE `message` LIKE :message"; $q = $pdo->prepare($sql); $q->execute(array(':message' => $vals[':message'])); $resp = $q->fetchAll(); foreach ($resp as $row) { throw new Exception('Please do not post the same message twice!'); } $sql = "INSERT INTO messages (from, to, name, subject, message) VALUES (:from, :to, :name, :subject, :message)"; $q = $pdo->prepare($sql); $q->execute($vals); } catch(PDOException $e) { echo $e->getMessage(); }

and the first print_r gives

Array ( [:from] => abc@gmail.com [:to] => lala@me.com [:name] => abc [:subject] => abc [:message] => abc )

which is expected (none are null)

but it outputs the error

for full : https://stackoverflow.com/...have-an-error-in-you

The Forum post is edited by Edward D. Clemmer Apr 7