• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Unknown column 'latitude' in 'field list'

Unknown column 'latitude' in 'field list' 7 years 9 months ago #37129

  • hagen_fenris
  • hagen_fenris's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 2
Hi,
i´ve created a form 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.
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);
}

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.
The administrator has disabled public write access.

Unknown column 'latitude' in 'field list' 7 years 9 months ago #37152

  • hagen_fenris
  • hagen_fenris's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 2
Hmmm....noone a idea how to split the la/Lng into separate fields and write them to #__content?
The administrator has disabled public write access.

Unknown column 'latitude' in 'field list' 7 years 7 months ago #37410

  • dlm
  • dlm's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 71
Did you solve this by now?

I have the same issue. I add some value to (for example) $data["longitude"] = $value

The value is saved in the DB in the column longitude

however,
I get an error Unknown column 'longitude' in 'field list'
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!