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

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
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

Hello,

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.

Code:
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.



Questions:
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
  #2  
Old 11-21-2015, 12:08 AM
mbrando mbrando is offline
Junior Member
 
Join Date: Dec 2008
Posts: 22
Default

Hello,

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
    mt_cfvalues
    j25_mt_cl

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

- Mike
Reply With Quote
Reply

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.