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

Get started

i have this error while adding a youtube video | Forum

Topic location: Forum home » Support » Bug reports and troubleshooting

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 Dec 16 '20

i am trying to add videos on youtube videos are no longer embedded on the my website

Onur Dec 16 '20

not more working videos plugin

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.

Leader

Patricia Zorrilla Dec 17 '20

Solved!

Download the patch for free:

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

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

Leader

Patricia Zorrilla Dec 17 '20

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

Sorry for the delay!

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 Dec 19 '20

Wont allow me to download.

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!

#10

David Dec 19 '20

I love the site! I sincerely do LOVE it. I think it's a great thing you're doing!

#11

Leader

dave Jan 13 '21

glad you got it sorted, and marcus its not abandoned, its just slow..

#12

Edward D. Clemmer Apr 7 '21

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 '21

#13