Go Back   Mosets Community > Mosets Tree 3.x > Discussions, Troubleshooting & Problems

Thread Tools Search this Thread Display Modes
Old 11-20-2015, 09:19 PM
mbrando mbrando is offline
Junior Member
Join Date: Dec 2008
Posts: 22
Default Listing summary does not show field data


I setup Moset 3.6.6 on Joomla 3.4.5. Wanted to setup categories for the 50 US states and used the SQL insert like this to create the 50 categories.

INSERT INTO `j25_mt_cats` (`cat_name`, `alias`, `cat_desc`, `cat_parent`, `cat_published`, `cat_approved`) VALUES ('Michigan', 'michigan', '', 0, 1, 1);
I did a test import of 20 records with the categories assigned and it worked well. However, after I used mtimport for CSV of the 12,271 records no data displays when viewing the category listing of say Georgia. I went in and saved a record manually after import and it now displays.

1) What is missing from the upload that makes them no visible?

2) Why does saving a record allow it to display?

3) Can this be corrected with an SQL statement?

- Mike
Reply With Quote
Old 11-21-2015, 12:08 AM
mbrando mbrando is offline
Junior Member
Join Date: Dec 2008
Posts: 22


Okay here is an update.

I noticed that there were some fields that displayed duplicates of custom fields. Some would show two specialty fields with data.

Then it hit me that the import die on the first try with an error. I think there was a bad cat_id. It was some text or something.

I had to go back truncate the following tables
  • mt_links

Then re-import and that worked. summary data now displays correctly.

- Mike
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT +8. The time now is 08:11 PM.

Copyright © 2005-2010 Mosets Consulting

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.