search

wind-project / wind

WiND is a Web application for managing a database of wireless nodes.
GNU Affero General Public License v3.0
33 stars 31 forks source link

MySQL error #55

Closed krisken closed 10 years ago

krisken commented 10 years ago

Hello,

When I want to create the links (backbone, AP, ...) on a node, i always get the same error:

1292: Incorrect datetime value: '-- ::' for column 'due_date' at row 1

Last MySQL query: INSERT INTO links (type, protocol, ssid, channel, frequency, status, due_date, equipment, node_id, peer_node_id, peer_ap_id, date_in) VALUES ('ap', NULL, 'Gent Watersportbaan', NULL, '2412', 'active', '-- ::', NULL, '1', NULL, NULL, '2014-07-17 14:36:12')

I already tried to add the date in the field "due_date" as 01-01-2014 00:00:00 but that doesn't help.

I've installed WiND today (17/07/2014) using Github.

krisken commented 10 years ago

Complete error on top of the page: Notice: Undefined index: CONDATETIME_linksdue_date_Day in /home/u0072/domains/wifinode.be/public_html/includes/pages/node_editor/node_editor_link.php on line 83 Notice: Undefined index: CONDATETIME_links__due_date_Month in /home/u0072/domains/wifinode.be/public_html/includes/pages/node_editor/node_editor_link.php on line 84 Notice: Undefined index: CONDATETIME_linksdue_date_Year in /home/u0072/domains/wifinode.be/public_html/includes/pages/node_editor/node_editor_link.php on line 85 Notice: Undefined index: CONDATETIME_linksdue_date_Hour in /home/u0072/domains/wifinode.be/public_html/includes/pages/node_editor/node_editor_link.php on line 86 Notice: Undefined index: CONDATETIME_links__due_date_Minute in /home/u0072/domains/wifinode.be/public_html/includes/pages/node_editor/node_editor_link.php on line 87 Notice: Undefined index: CONDATETIME_linksdue_date_Second in /home/u0072/domains/wifinode.be/public_html/includes/pages/node_editor/node_editor_link.php on line 88

ysamouhos commented 10 years ago

Hello Krisken,

Thank you for the bug report.

I will fix it asap.

ysamouhos commented 10 years ago

EDIT.

Fixed in trunk commit https://github.com/wind-project/wind/commit/71f267c1afd34df3add260ba655b565126cfbbac

Can you apply this change and try again?

krisken commented 10 years ago

Hello ysamouhos!

Could you please help me a bit with this update? The previous time i've downloaded everything with git clone. But then it created a directory "wind". Because i didn't want to have that, i replaced everything from the /wind directory directly into the main folder. But how do i have to update now? I'm not familiar with github at all :)

ysamouhos commented 10 years ago

Since it's a minor update you don't have to do everything from scratch.

Just edit the file includes/pages/node_editor/node_editor_link.php

and do the changes that you see if you click on the link bellow.. In red are the deleted entries and in green the new ones.

https://github.com/wind-project/wind/commit/71f267c1afd34df3add260ba655b565126cfbbac