RSForm Pro: Unknown column 'latitude' in 'field list'

hagen_fenris
Topic Author
Offline
Elite Member

8 years 3 months ago #11244 by hagen_fenris

RSForm Pro: Unknown column 'latitude' in 'field list' was created by hagen_fenris

Hi,
i´ve created a form with RSForm Pro including a map which allows the user to set a placemark.
I need to split the lat/lng into separate variables to store it at the datanbase.
Therefore i`m using the follow php-script wich i`ve added to the after-form-section.

Code:

foreach($mappings as $mapping)
{
  $data = unserialize($mapping->data);
  $coords = explode(",", $_POST['form']['Where']); 
  $lat = $coords[0];
  $lng = $coords[1];
 
  $data["latitude"] = strip_tags($lat);
  $data["longitude"] = strip_tags($lng);
 
  $mapping->data = serialize($data);
}

The Code is from here: wiki.zhuk.cc/index.php/Zh_GoogleMap_RSForm :)

Inside the mapping im using {latitude} to add the value to the db.
If i fill out the form at the frontpage the follow error occures:
"Warning Unknown column 'latitude' in 'field list'"

I don`t know what could be wrong...hopefully someone can help me.
At the RSForm-Forum i haven`t found somethin usefull...i`ve posted the problem there too a view days ago but no answer since now.

Please Log in or Create an account to join the conversation.

Dima
Offline
Platinum Member

8 years 3 months ago #11245 by Dima

Replied by Dima on topic RSForm Pro: Unknown column 'latitude' in 'field list'

Hi.
Sorry for delay, I just returned from my little vacation. As I understand you right, this is only warning message, but data is entering into database.
If it is true, I can try to contact to RS Forms developers and ask how I can pass my data to my tables without this warnings.

Don't forget support my developments: post review in JED , donate , help with translation

Please Log in or Create an account to join the conversation.

hagen_fenris
Topic Author
Offline
Elite Member

8 years 3 months ago #11260 by hagen_fenris

Replied by hagen_fenris on topic RSForm Pro: Unknown column 'latitude' in 'field list'

Hi,
i´m trying to insert the lat/lng into #__content.
I´ve create a form, just like in your manual, and inserted the php-code to explode the lat/lng from the map-field.

Does the php-code rteturn a string or number/integer?

Please Log in or Create an account to join the conversation.

Time to create page: 0.195 seconds